Alexandro Colorado wrote:
So I have a bunch of fields on a MySQL table that has a NULL value on
the date-type fields.
However when I open the table on Base I get an error saying:
""
Value '0000-00-00' can not be represented as java.sql.Date
""
I change the mask from MM/DD/YYYY into YYYY-MM-DD which is the MySQL
format but still got the same error.
Hmm, I just fired up 2.3 stable, against MySQl 5.0.11 and don't have
any problems with NULL date fields at all. For date controls and pattern
controls with edit masks, bot strict and not. I am non XP at the moment
however, I might give it a try under Ubuntu also, but would need to
update to 2.3 on that PC.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
