[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.
Post Reply
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

[Tutorial] SQL syntax in odb file with HSQLDB

Post by r4zoli »

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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply