4D v15 R3
Is field value Null
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- _o_USE EXTERNAL DATABASE
- _o_USE INTERNAL DATABASE
4D v15 R3
Is field value Null
Is field value Null
| Is field value Null ( aField ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| aField | Field |
|
Field to be evaluated | |||||
| Function result | Boolean |
|
True = field is NULL, False = field is not NULL | |||||
The Is field value Null command returns True if the field designated by the aField parameter contains the NULL value, and False otherwise.
The NULL value is used by the SQL kernel of 4D. For more information, refer to the 4D SQL Reference manual.
The value returned by this command is only meaningful if the "" option is not checked in the field definition of the Structure editor. Otherwise, it always returns False.
See also
PROPERTIES
Product: 4D
Theme: SQL
Number:
964
HISTORY
Created: 4D v11 SQL
ARTICLE USAGE
4D Language Reference ( 4D v15 R3)
4D Language Reference ( 4D v15)
4D Language Reference ( 4D v15.4)
4D Language Reference ( 4D v15.3)
© 1985-2017 4D SAS / 4D, Inc. All rights reserved.