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
 

Erel

Administrator
Staff member
Licensed User
How are you changing the records?
You should use a query similar to:
B4X:
"UPDATE table SET Y = 34, X = 34, ... WHERE JobName = 'endless debugging'"
 

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