On 22 Jun 2013, at 7:27pm, e-mail mgbg25171 <mgbg25...@blueyonder.co.uk> wrote:
> I need to access a row just using numbers. > The row id's fine but can I specify the table using a numeric id too? This command can be used to get tables numbered: SELECT rowid,name FROM sqlite_master WHERE type='table' However, if you have tables A, B and C and delete one of them, the numbers for other tables can change. Even creating or deleting indexes can change rowids. So it’s valid only until your schema changes in some way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
