Thanks very much Simon Looks like plan B then.
On 22 June 2013 19:40, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users