[Solved] Issues with HSQL 6.0 and 6.1 under LO 7 series.
Posted: Thu Jan 13, 2022 9:52 pm
Hi All,
Just wondering if anyone has the same "issues" I encounter with my Split Databases since the LO 7 series were introduced.
With this introduction, when using HSQLDB 6.0 and now 6.1 on Ubuntu 20.04, I lost the ability to:
1. add double quotes ("); our databases use double quotes ("), for e.g. "tCity"."CityID".
2. add single quote (') in e.g. 'MM/DD/YYYY' in a TO_CHAR( "tProjectDateTime"."ProjectDateChanged", 'MM/DD/YYYY' )
3. add a 'Tab' for indenting a line.
I have to copy the Query into a text editor to modify and paste it back into LO Base.
Reverted back to LO 6.4.7.2, as the last version without these problems.
Dream
Just wondering if anyone has the same "issues" I encounter with my Split Databases since the LO 7 series were introduced.
With this introduction, when using HSQLDB 6.0 and now 6.1 on Ubuntu 20.04, I lost the ability to:
1. add double quotes ("); our databases use double quotes ("), for e.g. "tCity"."CityID".
2. add single quote (') in e.g. 'MM/DD/YYYY' in a TO_CHAR( "tProjectDateTime"."ProjectDateChanged", 'MM/DD/YYYY' )
3. add a 'Tab' for indenting a line.
I have to copy the Query into a text editor to modify and paste it back into LO Base.
Reverted back to LO 6.4.7.2, as the last version without these problems.
Dream