SQL Question

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

  1. ceaser

    ceaser Active Member Licensed User

    Hi

    I need help again:sign0085:

    How can I force that values get stored in the Database to a certain row? Say I want to store data in row 1 or row 10, etc. In NSBasic I can do it.

    Thanks
    Michael
     
  2. BjornF

    BjornF Active Member Licensed User

    Dear Michael,

    why do you want to do that? As Erel already said in this thread:
    http://www.basic4ppc.com/forum/questions-help-needed/2748-sqlite-data-sequence.html

    you can just order the records (just add a column "RowNumber" and order by that when you open the database).

    If you want to just change some data in a given row in the database then you can do that by using the UPDATE command.
    E.g. "UPDATE Table1 SET Column1="' & TheCol1Value & "' WHERE RowNumber='" & TheRowNumber & "'"

    all the best,

    Björn
     
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