By default any column value in the query that is null
will just be
created in the database file as an empty string value. For some applications
it may be neccessary to distinguish the null
value from empty strings.
You can redefine the value used for a null
by using the
DEFINE predefined macro and setting the environment variable
NULL, as in the example below.
%%DEFINE NULL -
The above sets the value to use for a null
to the dash character.
Note that like NAMCOL the NULL directive is globally applied to all queries in the GRG file and cannot be set on a per-query basis.
Go to the first, previous, next, last section, table of contents.