[Tutorial] SQL syntax in odb file with HSQLDB

Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

[Tutorial] SQL syntax in odb file with HSQLDB

Postby r4zoli » Thu Jun 11, 2009 7:46 am

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

Return to Base

Who is online

Users browsing this forum: No registered users and 2 guests