I tried to split a new database with one simple table and received this same Illegal Argument message on trying to open the table2.
In my original database I had only one image file and I was using the LONGVARBINARY variable3.
Have attached the script file for the latest issue.
After your post I tried to replicate the error but I now get an error message "
Illegal Argument Exception" when trying to open the tables folder in the Base GUI - Some extra information that may or may not be relevant :1.
The use of 'outer-joins' will further multiply the size of a result-set, so careful memory considerations may be necessary.
If this scheme would exceed your available RAM, then consider 'disk-based result sets' at the expense of performance on-the-margin. Before your post I tried to rework and rework the split by trying to change the table structure through SQL commands(after the split), even trying to reset read only for table properties.
Hi Villeroy, thanks for the instructions and the files.
I got as far as trying to install your extension as in line 5.
Would appreciate a pointer or two how to construct the code for use in my table...... By the way that CURRENT_DATE insert was the last of my many trials... DATEADD is not part of the built-in HSQLDB 1.8 shipped with this office suite.
Am using Apache 3.4.1 on Windows Vistaqueries everything plus the calculated expiry date from the "Registration" table. You need to connect your database document to HSQLDB 2.x or some other database engine having that function.
Thanks for the feedback and the clarifications guys.
I had seen the exclusion lists on line but had made a very basic error of assuming I was using the latest version because I had downloaded the latest Open Office.
When I go into the database file to change the names of the files, the script file and the properties file default to just db and then have an association with windows notepad.