On 26-01-2014 17:09, Stephan Beal wrote:
Hi, all,is there a syntactical construct which will allow me to use a pragma in a subselect? e.g. i'm trying to do... sqlite> pragma table_info(vfile); cid|name|type|notnull|dflt_value|pk 0|id|INTEGER|0||1 1|vid|INTEGER|0||0 ... sqlite> select name from (pragma table_info(vfile)); Error: near "(": syntax error sqlite> select name from pragma table_info(vfile); Error: near "(": syntax error sqlite> create view v as pragma table_info(vfile); Error: near "pragma": syntax error sqlite> create view v as select (pragma table_info(vfile)); Error: near "table_info": syntax error sqlite> create view v as select pragma table_info(vfile); Error: near "(": syntax error Is this possible?
http://stackoverflow.com/questions/685206/sqlite-how-to-get-a-list-of-column-names answer: not in SQLite _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
