Sure, in that case there can be no sensible column name. In the great majority of cases though the select field will be of a single table column, with or without an expression. In those cases it will be helpful to get the non alias column name.
RBS On Sun, Jan 7, 2018 at 7:59 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 7 Jan 2018, at 6:16pm, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > > Would it be possible somehow to get the column full name if there is a > > column alias? > > > > For example if we have: > > > > select max(ID) as MaxID from table1 > > > > then I need to get max(ID) from the statement pointer. > > > > One would think that if sqlite3_column_name can get the alias name then > > somehow it must > > be possible to get the real column name. > > Suppose you had this > > SELECT (a + b) AS theSum FROM myTable > > What would the "real column name" be ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
