Thanks, that was what I suspected. Well, well, life is not perfect ;)
On Mon, May 26, 2014 at 4:50 PM, Igor Tandetnik <[email protected]> wrote: > On 5/26/2014 10:09 AM, Staffan Tylen wrote: > >> What I want to happen here is that the values in column A1 ('AA1' in this >> case) be returned >> > > You can't do that. SQL allows you to manipulate values, but not names. All > table and column names are set in stone when the query is prepared and the > execution plan is determined. > > You are effectively doing " select 'A1' from TAB1; " which of course is > very different from " select A1 from TAB1; " > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
