The NAMCOL variable when set means that the field names given to columns from an SQL query will take the name given in the SQL query itself. The default behaviour is to generate numbered names for columns in the same way as for delimited ascii files. Note that internally column names are held in uppercase and have a maximum of ten characters so SQL column names from the query may be truncated and will be mapped to uppercase for the purposes of field reference within the GRG file. The example program fragment below sets NAMCOL so that columns are named, there is no way to reset it once the value has been changed. Note also that it applies to all queries so either all database files defined as SQL queries will have named columns or none of them will.
%%DEFINE NAMCOL
If the NAMCOL variable is set then the column names for any text delimited database files will be taken from the field values of the first record in the file and that record will then be discarded.
Go to the first, previous, next, last section, table of contents.