SQL Question

[ceaser]

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

 

[BjornF]

Dear Michael,

why do you want to do that? As Erel already said in this thread:
http://www.b4x.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