On Wednesday 14 October 2009 3:00:34 pm John wrote: > On Wednesday 14 October 2009 02:51:07 pm Adrian Klaver wrote: > > On Tuesday 13 October 2009 2:11:28 pm John wrote: > > > On Tuesday 13 October 2009 01:34:08 pm Adrian Klaver wrote: > > > > On Tuesday 13 October 2009 12:18:10 pm John wrote: > > > > > OK I think Larry has discovered the problem but not the solution. > > > > > Drop the 'group by' and the select returns dates instead of string. > > > > > Also if 'DISTINCT' is use and not 'GROUP BY' it works - returns > > > > > dates. Also using all the fields in the 'GROUP BY 1,2,3,4,5,6' > > > > > does not work either. > > > > > > > > > > Johnf > > > > > > > > This is for the Windows case right? > > > > > > Yes - We get a string for the dates when the select statement contains > > > a 'GROUP BY' on windows XP and VISTA. > > > > > > Johnf > > > > Something about passing the data through sqlite is different between the > > Windows and Linux versions. You might want to check what version of > > sqlite3 is installed on each machine. The sqlite version listed in your > > previous email is for the pysqlite/sqlite3 module. The sqlite version > > should be 3.X.X . > > OK using sqlite3.sqlite_version from python produces > > Windows > 3.3.4 > > Linux > 3.5.7 > > Interesting but is there something I do about the windows being behind the > linux version. It's part of the install routine for python (windows). > > Johnf >
Good question, on Linux I usually just use symlinks. For the moment though that may not be necessary, my Linux machine is using 3.3.10 and working like your Linux instance. I do not see anything in the change file that would indicate a change between 3.3.4 and 3.3.10 in this area. So before scrambling your Sqlite versions, further investigation is needed. Not something I can do right at this moment, but I will get back to it. -- Adrian Klaver akla...@comcast.net _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/200910141747.14188.akla...@comcast.net