Hi Tony, > So having ported my data from MySQL to OOo Base, I now need to get my macros > working. There are apparently some differences here, since what used to work > with MySQL/ODBC now fails. > > Specifically, I an getting 'table not found in statement' when trying to > retrieve, though the table name is definitely correct. I have tried various > permutations without success. > > Is there some place where differences are documented?
Not that I know. One known problem is that HSQLDB is more nitpicking about case: If your SQL statements contain table/column names, you should quote them, else the HSQLDB query engine internally translates them to UPPER CASE, and then doesn't find them, because your real table/column names are probably MixedCase. There's an issue for this, but I don't have the number at hand. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
