[sqlite] Can we access table column using field and index instead of name?

2012-02-23 Thread Rick Guizawa 
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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can we access table column using field and index instead of name?

2012-02-23 Thread Simon Slavin 

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