Frank, Andrew, and community friends: Could you please test the following and summarize the results at your convenience?
My PC is in an uncertain OO Base state which Frank and Andrew are helping to resolve as mentioned in the discussion thread of "2.0.3 *.odb Table section access failure". I would like to avoid destruction of the PC state before we figure out the root cause. Furthermore, I am concerned that test results on my PC may not be reliable due to this unresolved problem. Thanks. Ray ----- The data parameter issue discussed so far seems to represent an opportunity for OO Base to broaden its capability with a simpler design and implementation. Please mention in test results: OS type OO JVM setting DB file nature stand alone (outside of *.odb) embedded inside *.odb Connection type to embedded *.odb JDBC to external file HSQL stand alone SQL parsing path OO Base GUI OO Base CUI (Tool - SQL) HSQL native (no OO) Test 1: Does HSQL DB 1.8.0.5 (stand alone, no OO) accept and store data parameters in *.script files? Suggest both URL's: jdbc:hsqldb:file:<your file location> file mode jdbc:hsqldb:hsql//<localhost>/ server mode The past results for these URL's appear to be different. It is already shown in previous tests that HSQL 1.8.0.5 CUI does not "execute" SQL statements with data parameters. Test 2: Setup an OO Base JDBC connection to an external HSQL DB (set of files). Does OO Base SQL CUI (bypassing GUI) accept and store data parameters in <root name>.script outside of the *.odb file? Test 3: Does OO Base SQL CUI (bypassing GUI) plus embedded HSQL DB 1.8.0.5 accept and store data parameters in database/script inside the *.odb file?
