GetDynamicNumber
PowerScript function
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
|
1 |
DynamicDescriptionArea.GetDynamicNumber ( index ) |
|
Argument |
Description |
|---|---|
|
DynamicDescriptionArea |
The name of the DynamicDescriptionArea, usually |
|
index |
An integer identifying the output parameter descriptor |
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:
|
1 2 |
Integer DeptId DeptId = SQLDA.GetDynamicNumber(2) |
For an example of retrieving data from the DynamicDescriptionArea,
see GetDynamicDate.
See also