SQLColumnNullable - cDbUpdateFunctionLibrary
To set a SQL table column to accept NULL values or not.
Type: Function
Parameters: Handle hTable, Integer iColumn Boolean bState
Parameter |
Description |
hTable |
A file handle to the table name. Same as the Filelist.cfg slot number. |
iColumn |
The column number to set the default value for |
bState |
Pass True to allow NULL values for the column |
Syntax
Function SQLColumnNullable Handle hTable Integer iColumn Boolean bState Returns Boolean
Call: |
Get SQLColumnNullable TableName.File_Number iColumn False to bOK |
Description
Use it to set if a column should accept NULL values or not. Pass a boolean False value to not allow NULL values.
See Also
NULL Values and Defaults for more information.
Example
Procedure OnUpdate
Boolean bOK
Get SQLColumnNullable Customer.File_Number (RefTable(Customer.Name)) False to bOK
End_Procedure