Hi,

I've detected a problem with the code I wrote here.
Normally sqlite3, when returning a result column in the format 
tablename.columnname, the real table name is returned, regardless if it was 
aliased in the original sql statement.
I've just discovered that if you do a 'select distinct' sqlite3 returns the 
tablename alias, and as a result fails to resolve the field type for that 
column.
-- 
Kris Groves

 Project Manager / Software Engineer                   mm-lab GmbH
 Phone:  +49 7154 827 323                      Stammheimer Str. 10
 Fax:    +49 7154 827 350                     D-70806 Kornwestheim
 [EMAIL PROTECTED]                                 www.mmlab.de

            Domicile of Company: Kornwestheim, Germany
   District Court - Court of Registration Stuttgart HRB 207257
          Managing Directors: Bernd Herrmann, Lothar Krank, 
                 Michael Meiser, Dr. Andreas Streit              


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel

Reply via email to