I'm trying to port some stuff to OpenOffice.org from MS-Office.
Currently we store a lot of stuff in MS-Access 2000.
I figured out how to connect OO to a MySQL DB via MyODBC 3.51. But there
are a few problems.
1) I need filtering by date-fileds. Many of our tables have the fields
validFrom & validUntil so I can filter against the system date. In
Access I have some stored queries that do this.
Now StarOffice & OpenOffice keep complaining that I couldn't compare
those fields with date values, regardless whether I chose DATE, DATETIME
or TIMESTAMP as data type of the field, when I try to compare against
datevalue().
Is there another date function ?
I can however enter fixed dates like "< 23.2.2002". In the visual query
editor OO translates this automatically to "< #2002.02.23#" and to "{D
#2002-02-23#}" in the SQL-view.
But I need those queries dynamically against the system-date though.
2) Via MyODBC connected tables are generally read-only in all of the
graphical interfaces of OO 641C. If set SO 5.2 to the same data source,
it works as expected, so it's an OO issue.
I can write to those tables when I use SQL INSERTs in OO.
And I can edit the data of a table in a query that does basically
"SELECT * FROM table;" whereas the same table is read-only in the
table-view.
The funny part is, that this doesn't work with all tables.
Some tables resist this trick completely and another one rejects "SELECT
* FROM table;" but accepts if I SELECT with a list of all fields of the
table instead of using "*".
Then there is one that gets read-only if I include a TIMESTAMP-field in
the SELECT but in another one the TIMESTAMP is OK.
Generally I can edit the field values at best, but I can't append new
rows in any of OO's dialogs.
Any ideas ?
cu ... A.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
