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