Thanks very much Simon Looks like plan B then.
On 22 June 2013 19:40, Simon Slavin <[email protected]> wrote: > > On 22 Jun 2013, at 7:27pm, e-mail mgbg25171 <[email protected]> > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
