At various times in various threads on this list it has been stated that the column name in a result set is not guaranteed unless one uses AS. IOW, one should say
select abc as abc from mytable where i=23; rather than just: select abc from mytable where i=23; I'm trying to find where on the SQLite website that is documented, if it is, so I can point someone at it. The Xojo documentation doesn't mwention this so either that is a potential problem for all us Xojo users or they've worked around it somehow in their SQLite wrapper. Thanks for a pointer. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users