Jay,
You have a good idea which I think I should be able to incorporate. The
syntax that worked for me is -
UPDATE table_name SET `column_id`=NULL WHERE `column_id` = '-00-00';
Thanks for the suggestion!
David ...
On 12/17/2012 7:16 PM, Jay Lozier wrote:
On 12/17/2012 05:35 PM, receiver
got it working.
Girvin Herr
receiver wrote:
It works!!! The fact that this rather ugly bit of coding is confined
to the .odb file is the good news. It can be out of sight and out of
mind for my technically challenged end user community.
Many thanks for a pretty useful tip
'-00-00' can not be
represented as java.sql.Date
Date: Sun, 16 Dec 2012 14:59:50 + (GMT)
From: Tom Davies tomdavie...@yahoo.co.uk
Reply-To: Tom Davies tomdavie...@yahoo.co.uk
To: receiver recei...@gowdygroup.net, users@global.libreoffice.org
users@global.libreoffice.org
Hi
I'm trying to create a LibreOffice (3.6.4) Base document which utilizes
a MySQL database. I have installed the MySQL Connector J (5.1.22) and
have good results with one significant exception. The subject error
prevents display of a table which does contain dates. I suspect that
this may be a
not be
represented as java.sql.Date
Date: Sat, 15 Dec 2012 17:54:39 -0500
From: Jay Lozier jsloz...@gmail.com
To: users@global.libreoffice.org
On 12/15/2012 04:03 PM, receiver wrote:
I'm trying to create a LibreOffice (3.6.4) Base document which utilizes
a MySQL database. I have installed
J
5.1.22, MySQL Server 5.5.16
David ...
On 12/15/2012 6:10 PM, Girvin R. Herr wrote:
receiver wrote:
I'm trying to create a LibreOffice (3.6.4) Base document which
utilizes a MySQL database. I have installed the MySQL Connector J
(5.1.22) and have good results with one significant