Click or drag to resize

SQLSelect.NullAsBlank Property

X#
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
Syntax
 VIRTUAL PROPERTY NullAsBlank AS USUAL GET SET 
Request Example View Source

Property Value

Type: Usual
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
Remarks
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value). Proper support for SQL NULL values would be to set this value to TRUE.

If TRUE, null fields will have the following values:

VO TypeNULL Value
STRINGNULL_STRING
DATENULL_DATE
LOGICFALSE
FLOAT0
LONG0
All othersNIL
If FALSE, all null fields will be NIL. Note that the default behavior (FALSE) can cause conflicts with strongly typed variables, as NIL cannot be assigned to strongly typed variables.
See Also