Keith Clark wrote:
I seem to have a problem with a timestamp field and mySQL. When I view
the table it says "Cannot convert timestamp"
What to do?
Well - with just that to go on I would say look at the option
zeroDateTimeBehavior for the JDBC driver.
The MySQL documentation covers this - in brief, MySQL allows a
timestanmp to consist of all zeros ( not all DBMS do that )
Base does not support this - so you need to tell the driver to convert
such a field value to a NULL.
The specific reference is located at
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
In your Base file you add this with
Edit > Database > properties
On the Advanced Properies tab first field "Name of the MySQL database"
use standard JDBC syntax to add this.
For instance if you database is named "kclark" the property would hold
kclark?zeroDateTimeBehavior=convertToNull
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
