Posts by debasisdas

This may be useful to you.

If you have some sample data in an excell sheet or in .CSV format, you can upload those into tha table using SQL*LOADER.

There is a bult in login form available in Vb 6.0 IDE.

Try to enhance that.

You need to design your own database objects.

You need to read this and this.

try using .05 in place of '.05'

Death is hereditary.

The answer is a big NO.

You need to compile the above piece of code into a function and use the output as your PK and populate in the form. Later insert the same value into the table.

That is how you reuse the same piece code.

Even if you are a minority of one, the truth is the truth.

Which control you are using to create the graph ?

Does that control support spider web graph ?

If it supports you just need to change the property, if not you can't do that.

You may need to look for some other control for the purpose.

Please follow these links

SQL
http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf

PL/SQL
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261.pdf

OutpatientDetails should be a subset of InpatientDetails.

Technically only the patients how have come in can only go out.

You need to maintain the same id in both the tables.

Later if it is required you need to join both the tables based on the ID field for any reporting or any other purpose.

Please post, what you have done so far and in which step you are struck, for further assistance from our experts.

if you have installed oracle server in the system, you have to set password during installation atleast for SYS and SYSTEM accounts.

For all those options you need to use a better reporting tool. Atleast earlier versions of Crystal Report.

Visual Basic 5.0 and Crystal Reports 4.6 are not 64 bit application, so are not supported on Windows 7.

Why you need to use INTO clause in the SELECT statement ?
Elements after INTO clause needs to be variables and those needs to be declared in the current scope.

How are you capturing the flow of process of a SQL procedure ?

Only if you are ready to pay the full amount in advance.

Use this and set the chart type as desired.

Creating view is a better option for that.

This info is not enough to provide you with any solution. You need to hire a professional for the job.

You are using MySQL or Oracle ?

You command you tried is not a valid SQL syntax.

What exactly you mean by Horizontal Fragmentation ?

What are you trying to achieve ?

That is my first and last name concatenated.

Creating database at run time does not make any sense.

You need to use EXECUTE IMMEDIATE to create tables at run time.

You need to read this to understand the basics.

try this

text2.text = list1.list (text1.text)

You need to use filelistbox for the purpose.

How you decide which is the most recent upload ?

Are you storing the upload date and time in the DB table ?

What you want to do ?

use either one or all the parameters to filter records ?

You need to understand the basics correctly. scott is a schema within the database not the other way around.

You need to read this and later on go for this.

Better to load the dates as string and convert later.

Hope you did not forget to COMMIT, after executing the INSERT.

That type of chart is displayed if the chart type is Exploded pie 3d chart. I am not sure if the chart control inbuilt to Vb 6.0 has that type support.

try this

Select count(*) from TimeLog where EM_Name = '.................

If it returns 1 display the message else proceed further and save the data.

You need to ensure that EM_Name is the primary key of the table

Welcome aboard.

What kind of vulnerability ? Is it an injection attack ?

What exactly you mean by explode a piece of a pie chart ?

FYI -- dll is a compiled sub or function only.

How you convert the.zip file into binary stream ?

Please read more here.

You should have downloaded the install set from the official site.

Better let a professional do the job of installation and configuration of database for you.

You need to subtract the dates. Try to use DateDiff Function.

If by attaching you means to say play an audio file , you can use media player control, MM control or use the API Playsound.

Hi Justin,

Welcome on board.

I really like your attitude.