Me And SQLLite Again

ceaser

Active Member
Licensed User
Hi Everybody

Please help!:sign0085: I have a database consisting of the following:

Jobname, Surveyor, Job Description, Coordinate System, Y X & Z coordinates of last station setup, etc............

I can have more than one "Jobname", but they must all be different. No 2 Jobs may have the same name.

Using the database and I say change the Y X & Z coordinates of the station setup, then the program adds an additional entry in the database (duplicates the Jobname), which I don't want.

The "Jobname" is the primary key and if I change something attached to the Jobname, it must update the database and not create another entry.

With NSBasic I used the keyword "Primary", which in this case will be the Jobname.

:sign0085:

Thanks
Michael alias Ceaser
 

ceaser

Active Member
Licensed User
SQLLite

Thanks Erel!:sign0188:

Sorry for all those questions, but sometimes I cannot see the wood in the forest! These stupid questions will get less as I get to know your platform better.

Thanks
Michael
 
Top