This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D Language Reference
-
- SQL
-
-
Overview of SQL Commands
-
On SQL Authentication Database Method
-
Begin SQL
-
End SQL
-
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 current data source
-
SQL GET DATA SOURCE LIST
-
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
-
SET FIELD VALUE NULL
| SET FIELD VALUE NULL ( aField ) | ||||||||
| Parameter | Type | Description | ||||||
| aField | Field |
|
Field where NULL value is to be attributed | |||||
The SET FIELD VALUE NULL command assigns the NULL value to the field designated by the aField parameter.
The NULL value is used by the SQL kernel of 4D. For more information, please refer to the 4D SQL Reference manual.
Notes:
- It is possible to disallow the Null value for 4D fields at the Structure editor level (see the Design Reference manual).
- SET FIELD VALUE NULL erases the contents of object fields.
Product: 4D
Theme: SQL
Number:
965
Created: 4D v11 SQL
4D Language Reference ( 4D v20)
4D Language Reference ( 4D v20.1)
4D Language Reference ( 4D v20.2)
4D Language Reference ( 4D v20.3)
4D Language Reference ( 4D v20.4)
4D Language Reference ( 4D v20.5)
4D Language Reference ( 4D v20.6)
