SQLSelect.NullAsBlank Property (Typed) | |
A logical value determining whether SQL NULL values are strongly typed (TRUE) or not (FALSE, default value).
Namespace:
XSharp.VO.SDK
Assembly:
XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.19
Syntax VIRTUAL PROPERTY NullAsBlank AS LOGIC GET SET
public virtual bool NullAsBlank { get; set; }
Request Example
View SourceProperty Value
Type:
LogicA 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 Type | NULL Value |
---|
STRING | NULL_STRING |
DATE | NULL_DATE |
LOGIC | FALSE |
FLOAT | 0 |
LONG | 0 |
All others | NIL |
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