Simon,
BTW, by using "pragma full_column_names=1" and "pragma
short_column_names=0", the sentence:
SELECT * FROM mytable AS myalias
returns the column names as myalias.col1, myalias.col2, etc., which is
perfectly correct. But I'm aware that those pragma are deprecated. And
in fact, if you use them, other errors arise.
Regards,
Jose F. Gimenez
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
