On 28 Aug 2014, at 12:47am, Zachary Yates <zachary.ya...@orolia.com> wrote:
> That's not actually the issue. When I run the query using the SQLite console > or via another driver, (for example using 0xDBE + Xerial), the column names > are returned exactly as they are specified in the query. > > The problem is that all of the column names return the same string: > "Country", surely this isn't the expected behavior? How am I supposed to tell > the columns apart other than their ordinal position? By specifying the name you want SQLite to give them, using an AS clause for each one. I'm sorry that that's annoying you, but it is the truth. Go look for the specification for default column names returned by SELECT in the SQL standard. You won't find one. The assumption back when SQL was devised was that everyone would use ordinal positions, since back then string processing was 'expensive' and one didn't use them except when necessary. Yes, you're free to consider this a peculiarity of the ADO driver. It might be easily fixable. But it's not a bug. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
