Bram, Thanks, I will try a newer FPC. I think you're right about NULL rather than 0. I specified NOT NULL on the date fields in the schema but I believe that the ODBC driver for Mysql converts the special 0 value to NULL because ODBC cannot handle them.
Dave. On Tue, 2006-06-06 at 07:56 +0200, Bram Kuijvenhoven wrote: > This bug was fixed right after FPC 2.0.2 was released: > It was fixed in revision 1710: > http://www.freepascal.org/cgi-bin/viewcvs.cgi/trunk/fcl/db/sqldb/odbc/odbcconn.pas?rev=3469&view=log > But 2.0.2 has revision 1702: > http://www.freepascal.org/cgi-bin/viewcvs.cgi/tags/release_2_0_2/fcl/db/sqldb/odbc/?rev=3813 > > The fix was for NULL fields; I assume that with 0 you mean NULL? > > Please test it with a newer FPC. Unfortunetely some of the FPC websites are > down this week for maintenance, but you can still > - get the sources from SVN > - download a snapshot from a mirror > - download a snapshot from http://www.de.freepascal.org/lazarus/ > - download a newer odbcconn.pas from SVN (or use the ViewCVS interface linked > above) and copy it to your projects' directory such that it will be used > instead of the one that is in the compiler. (You might also need newer > versions of other files, depending on which revision you pick) > > Regards, > > Bram _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
