Android Question SQLite set rowid new on a order by command

[Alexander Stolte]

Hello,

Because i work with the ROWID, is this a issue if the data change to a newer value and nothing happend, when i load all components new.

This does not work.

SQL1.ExecQuery("SELECT column1, column2 FROM table1 WHERE rowid=" & (i +1) & " ORDER BY time DESC")

Is there a way to reorder the rowid so that the newest time gets rowid 1?

if come a newer time from the database, i just update the row and reload new.

Greetings

 

[klaus]

Is there a way to reorder the rowid so that the newest time gets rowid 1?

No, you cannot.
Every time you add a new record rowid is incremented by one.
If you delete records, their rowids are lost all the other remain.

 

[Ricky D]

I always use primary keys that autoincrement

 

[DonManfred]

In SQLite, a column with type INTEGER PRIMARY KEY is an alias for the ROWID (except in WITHOUT ROWID tables) which is always a 64-bit signed integer.

rowid can not be changed as already answered by klaus.

 

[OliverA]

Hello,

Because i work with the ROWID, is this a issue if the data change to a newer value and nothing happend, when i load all components new.

This does not work.

SQL1.ExecQuery("SELECT column1, column2 FROM table1 WHERE rowid=" & (i +1) & " ORDER BY time DESC")

What are you trying to accomplish? Since you include rowid in your query with an equals comparison operator, this will return either one or zero results (one if the rowid exists and zero if not). So why the need for ORDER BY? Again, what are you trying to accomplish?

 

[DonManfred]

It is mandatory to sort the Output of the ONE result.
Sorry, i could´nt resist ;-)

PD: Sorry for "OffTopic"