Xbasic
SQL::ArgumentsSetNull Method
Syntax
Result_Flag as L = SetNull(Name as C, Type as C [, Usage as SQL::ArgumentUsage])
Arguments
- NameCharacter
The unique name property of an argument. See the SQL::Argument class.
- TypeCharacter
Defines the argument's data type. The data type can be one of the following values listed below:
- B
"Blob"
- C
"Character"
- D
"Date"
- L
"Logical"
- N
"Numeric"
- Y
"Short Time"
- T
"Time"
- UsageSQL::ArgumentUsage
Defines how the argument should be used. See SQL::ArgumentUsage Enumerated Type for more information.
Description
Set a value to NULL and (optionally) the usage of the argument.
Discussion
The SetNull() method adds or redefines the specified Argument as NULL. Returns true (.t.) if the operation is successful and false (.f.) if it fails.
dim args as SQL::Arguments
args.setNull("state", "C")You can optionally specify the usage of the argument. For example:
dim args as SQL::Arguments
args.setNull("age", "N", SQL::ArgumentUsage::InputOutputArgument)See Also