Simon,BTW, by using "pragma full_column_names=1" and "pragma short_column_names=0", the sentence:
SELECT * FROM mytable AS myaliasreturns 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
