Okay, since I can't connect to MySQL x86_64 version, I identified a couple of databases I can set up in HSQLDB. I tried with 1.9.79 (distributed with Suse9.3) without much success, so installed 1.9.118 from RPMs.
First task was to set up tables and transfer data. I did this by extracting from MySQL as a CSV and opening it in Calc. I then had much trial and error trying to transfer it into the database. By chance, I hit on the following - not sure if this is the recommended method. 1. Select All in spreadsheet and Copy. 2. in database document, select table, then Paste Special from context menu. 3. in dialogs, edit table name, select Append Data, accept default field equivalents, then Create. This seems to work fine, with two little problems. 1. If I've just created the table, I seem to need to close the database and re-open it before using it. I get a message when doing Create Special, something to the effect that the table is not defined (sorry, can't remember exact text). 2. The first record of the selection never seems to make it onto the database. (Solution: if possible, insert an empty row at the top of the spreadsheet) A couple of other niggles: 1. Forms created with wizard always seem to have Read-only in the title. In the case of Datasheet forms, this seems to be an accurate description! I never managed to enter anything. 2. The Forms toolbox seems to pop up from time to time, even when I don't actually have a database open. Cheers, TonyB --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
