|
DaoServer:NullAsBlank Access/Assign |
  
|
|
DaoServer:NullAsBlank Access/Assign |
|
Purpose
A logical value indicating whether the server should return NULL values as blank values of the proper datatype
Note
By default Dao returns NULL values in the database as NIL values. That can be very awkward if you for example want to calculate the sum of two fields. By setting NullAsBlank to TRUE null values are returned as blank values of the proper datatype:
| Field type | Blank value |
| Date | NULL_DATE |
| String | NULL_STRING |
| Numeric | 0 |
| Logic | FALSE |
| Object | NULL_OBJECT |
| Memo | NULL_STRING |
Class
See Also