The column SQLRecord field property
specifies the name of the database table column that is associated
with the field.
The default is the name of
the field. EGL uses the column name
and related field to create default SQL statements (seeSQL data access).
The column name
can be a quoted string, a character variable, or
a concatenation, as in the following example:
Record CustomerRecord type SQLRecord
customerNumber INT {column = "Column" :: "01"};
...
end
You must use a special syntax if a column name
is one of the following
SQL reserved words:
- CALL
- FROM
- GROUP
- HAVING
- INSERT
- ORDER
- SELECT
- SET
- UNION
- UPDATE
- VALUES
- WHERE
As shown in
the following example, each of those names must be
embedded in a double set of quotation marks, and each of the internal
quotation marks must be preceded by an escape character (\):
column = "\"SELECT\""
A similar situation applies if you use any of those reserved words
as a table name.