On December 7, 2019 6:04:36 p.m. EST, Tim Streater <t...@clothears.org.uk> wrote: >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
It's stated here, at least: <https://www.sqlite.org/c3ref/column_name.html> -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
