| SQL adaptation guide For Genero db 3.6x, 3.8x / Data manipulation | |
SQL object names, like table and column names, cannot be SQL reserved words in Genero db. An example of a common word which is part of the Genero db SQL grammar is 'level'
You must rename those table or column names that are Genero db reserved words. Genero db reserved keywords are listed in the Genero db documentation. Another solution is to enclose the table/column name in double quotes. Double-quoted table/column names are case-sensitive. If this double-quoted syntax is used, all subsequent references to this table/column must be in the same double-quoted format.