When you use odb files with HSQLDB built-in database engine, use syntax:
Use for database objects "double quotes", for literal text 'single quotes', || for the concatenation, and % same as the better known joker * .
A colon as the first character of variable. An example is :any_parameter.
The user will be asked for the value of this variable at the time that the select statement is run.
In date use single quote as in text literals.
Comments: -- comment, after saving query the comments disappears, remains in Query doc only when Direct SQL selected.
[Tutorial] SQL syntax in odb file with HSQLDB
Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
[Tutorial] SQL syntax in odb file with HSQLDB
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin