Android Question SQLite set rowid new on a order by command

Alexander Stolte

Expert
Licensed User
Longtime User
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.
B4X: 
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
 
Sort by date Sort by votes

klaus

Expert
Licensed User
Longtime User
Is there a way to reorder the rowid so that the newest time gets rowid 1?
Click to expand...
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.
 
Upvote 0

Ricky D

Well-Known Member
Licensed User
Longtime User
I always use primary keys that autoincrement
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
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?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Other B4A v12.0 has been released
2
Replies
35
Views
15K
Erel
S
  • Question
Android Question rowid not being kept for the lifetime of the database
Replies
2
Views
676
simonwilliamson
S
  • Question
Android Question SQLite: last_insert_rowid() [solved]
Replies
7
Views
2K
Albert Kallal
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
57K
Erel
R
  • Question
Android Question SQLITE problem. Column 'rowid' Does Not Exist?
Replies
3
Views
2K
RB Smissaert
R
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…