Configuration Command

Set the null indicator string.

null [STRING] 

STRING 

A string value representing the text to be displayed as the null indicator string. The default string is "Null".

Description

If a selected row contains a column that allows null values, and the column in that row has null data, this string is displayed in place of the data. If the display width for that column is set with the set command and the display width is shorter than the null string width, the column display width takes precedence. In other words, the null string is truncated to match the column width, just as if it were data.

If the null command is issued with no parameter, the null string is set to be empty (none). In this case, when data is retrieved with the null indicator set, the field is empty. This should be used only with a non-null field separator.

When this command is issued, the string is the rest of the command line, including white space, up to the statement terminator. This means the null string can be more than one word. To enter leading spaces or tabs, use the backslash (\) character.

Example

response to start

   start local SQL "eslsqlms"

   send "null NULL!\n" to SQL

 

response to line from SQL

   extract from input

      take to "|" FirstColumn

   if (FirstColumn = "Null!") then

      copy false to to FirstColumnData_BV
   end if