Description
Obtains numeric data from the DynamicDescriptionArea after you have executed a dynamic SQL statement.
Restriction
You can use this function only after executing Format 4 dynamic SQL statements.
Syntax
DynamicDescriptionArea.GetDynamicNumber ( index )
|
Argument |
Description |
|---|---|
|
DynamicDescriptionArea |
The name of the DynamicDescriptionArea, usually SQLDA. |
|
index |
An integer identifying the output parameter descriptor from which you want to get the data. Index must be less than or equal to the value in NumOutputs in DynamicDescriptionArea. |
Return value
Double.
Returns the numeric data in the output parameter descriptor identified by index in DynamicDescriptionArea. Returns 0 if an error occurs. If any argument's value is null, GetDynamicNumber returns null.
Usage
Use GetDynamicNumber when the value of OutParmType is TypeByte!, TypeInteger!, TypeDouble!, TypeLong!, TypeReal!, or TypeBoolean! for the value that you want to retrieve from the array.
For OutParmType values of TypeDecimal! or TypeLongLong!, use GetDynamicDecimal instead.
Examples
These statements set DeptId to the numeric data in the second output parameter descriptor:
Integer DeptId DeptId = SQLDA.GetDynamicNumber(2)
For an example of retrieving data from the DynamicDescriptionArea, see GetDynamicDate.
See also
