Base now ships with Hsqldb as its "native" database. This is not surprising since that DB engine is written in Java.
I can open MS Access .mdb files OK and run SQL queries successfully, so long as the queries don't contain dates!! For the life of me, I can't figure out how to format date information in a query so that it will work. I have successfully converted the .mdb files to SQL scripts to load the structure and data into MySQL. Queries from Base to MySQL (using the J/Connector interface) work when dates are enclosed on single or double quotes, just as they would from the command prompt or from phpmyAdmin. I have tried that to no avail in Base. I have also used the "#" symbol as in Access. None of these work. I have seen discussion in various places regarding the difficulty/complexity of formatting Date/Time data in Java. But, since any database is bound to contain date data, surely OpenOffice has found a way of hiding that complexity so that queries are not overly difficult to write. Help!! Please advise. Thanks John Wiginton
