Me And SQLLite Again

[ceaser]

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

 

[Erel]

How are you changing the records?
You should use a query similar to:

"UPDATE table SET Y = 34, X = 34, ... WHERE JobName = 'endless debugging'"

 

[agraham]

WHERE JobName = 'endless debugging'"

:sign0142:

 

[ceaser]

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