David B Copeland wrote:
Does anybody know if there are bugs in running Querys throught ODBC against MySql (4.1) tables with DATE field with a value of 0. I am using Lazarus SVN Revision 9406M with FPC 2.0.2, and when I Open the Query I get the error message "37904-2097-57345 is not a valid date specification.", whenever a date field in the result set from the Query has a value of 0. This will occur both in the Designer and in execution. Sometimes the string of numbers varies some.
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
