zeroisnull.htm
| Navigation: SQL Driver Strings(General) >====== ZEROISNULL ====== |    |
DRIVER(SQLDriver, '/ZEROISNULL = TRUE | FALSE' )
[ Nulls“ = ] SEND(file, '/ZEROISNULL [ = TRUE | FALSE ]' )
(NOTE: Not valid for ORACLE Accelerator)
ZEROISNULL lets the SQL Accelerator Drivers set DATE and TIME fields to zero (0) rather than null. By default (ZEROISNULL=TRUE), the SQL Accelerator Drivers assumes a DATE or TIME field with a value of zero (0) should be a null value in the backend database, and adjusts the values to NULL when writing to the backend. To allow the driver to set DATE and TIME fields to zero rather than null, set ZEROISNULL to FALSE.
See Also: ZERODATE
zeroisnull.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1