RSmith wrote: >There is no contract of which column names should be returned, no "incorrect" >headers and no guarantee, and no obligation from the
>standard or any other requirement. If you need the returned names to be >exactly something specific, then you need to use the "AS" >directive. I find it hard to imagine that ServiceStack.OrmLite does not know >this - but it is possible. This question would >probably get more useful replies on an OrmLite forum. OrmLite is very flexible in what it will accept for the column names in the DbDataReader. In the failing case the column names in the reader are all the same and they are all "view-name". That is clearly not sensible as there is no way to retrieve data from the reader by column name. Requiring an "AS" directive to select columns from a view when that is not required to select columns from a table seems basically incorrect to me. At the very least it is inconsistent. Then there is the output from the SQLite3 command-line shell which also prints the headers as all "view-name" for the failing case. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
