On 24 Feb 2012, at 1:45am, Rick Guizawa <guizaw...@gmail.com> wrote:
> Hi, would it be possible to reference a column in a table using other than > its name? For example, if I have : create table X ( a TEXT NOT NULL); would > it be possible to access x.a with something similar as x.field[0]? Thank's. No. Sorry, but there are no standards for that. However you can do a 'SELECT * FROM ...' and iterate through the columns until you find one with the correct name. Or you can use SQLite's PRAGMA function to list the columns in a table: <http://www.sqlite.org/draft/pragma.html#pragma_table_info> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users