Peng Yu wrote:
> There are cid's for each table. Is there a way to use "select" with
> cid's instead of their names?
>
> select * from pragma_table_info('test');
> cid name type notnull dflt_value pk
> ---------- ---------- ---------- ---------- ---------- ----------
> 0 id integer 0 1
> 1 value text 0 0
This cid value is generated on the fly by table_info, and not used anywhere
else.
You would have to run "SELECT name FROM pragma_table_info(...) WHERE cid = ?"
and then construct the actual SQL query with the returned column name.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
