Posts by debasisdas

You need to start with drawing a circle.

Gradually change its different parameters to create oval shapes and proceed further.

638

642

1. Do not use reserved key words as variables(Command,Connection etc).
2. Both of your SQL is syntactically wrong.

Timestamp will capture the exact time when the record was changed for each record.

What you have so far ?

646

646

650

652

???

656

..... direct give me code or project file .....

Don't ever expect that here.

You need to show some effort to get help from our experts.

Welcome to Daniweb.

660

664

652

652

652

652

You need to read this and this.

Also read this.

You need to store the password in the connection string itself.

Please find more on connectionstring.

648

648

better than the best

648

652

656

660

664

666

try something like this

select e.first_name
from employees e, goods g, orders o
where e.id = o.employee_id
and g.id = o.item_id

you need to modify this to suit your requirement.

666

or may be ...

668

672

Why not try using JOIN .

Join all the three tables and retrieve the data

no, i was asking about the table structures and their relations.

It is better to write a procedural block.

what is the relation between the tables ?

what exactly you are trying to do ?

You need to check the following links.

link1
link2
link3
link4

672

676

676

Can you have the data in a delimited format (ex. csv) rather than text format.

676

680

Will the length of the book, the chapter and that of the verse number will remain same ?

684

686

From the string in the text file how you know which is
1. the book name
2. the chapter
3. the vers

what is the database that you are using ?

You need to check for and handle NULL values in your Stored Procedure.