Me And SQLLite Again

Discussion in 'Questions (Windows Mobile)' started by ceaser, Aug 11, 2008.

  1. ceaser

    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
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    How are you changing the records?
    You should use a query similar to:
    Code:
    "UPDATE table SET Y = 34, X = 34, ... WHERE JobName = 'endless debugging'"
     
  3. agraham

    agraham Expert Licensed User

    :sign0142:
     
  4. 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
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice