View Single Post
  #1 (permalink)  
Old 08-11-2008, 04:47 PM
ceaser ceaser is offline
Senior Member
 
Join Date: May 2008
Posts: 118
Unhappy Me And SQLLite Again

Hi Everybody

Please help! 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.



Thanks
Michael alias Ceaser
Reply With Quote