[Tutorial] SQL syntax in odb file with HSQLDB
Posted: 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.
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.