column

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:
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.


Feedback