SQLSelect.NullAsBlank Property |  |
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.21
SyntaxRequest Example
View Source
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
Property Value
Type: UsualA 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 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.
If TRUE, null fields will have the following values:
| VO Type | NULL Value |
|---|---|
| STRING | NULL_STRING |
| DATE | NULL_DATE |
| LOGIC | FALSE |
| FLOAT | 0 |
| LONG | 0 |
| All others | NIL |
See Also