DynamicDescriptionArea is a PowerBuilder system object that stores information about the input and output parameters used in Format 4 of dynamic SQL.
PowerBuilder provides a global DynamicDescriptionArea named SQLDA that you can use when you need a DynamicDescriptionArea variable. If necessary, you can declare and create additional variables of this type using this system object as the datatype.
For more information about using dynamic SQL, see the section called “Using dynamic SQL” in PowerScript Reference.
DynamicDescriptionArea property |
Datatype |
Description |
---|---|---|
ClassDefinition |
PowerObject |
An object of type PowerObject containing information about the class definition of the object or control. |
NumInputs |
Integer |
Specifies the number of input parameters found in the dynamic SQL PREPARE statement. PowerBuilder populates this property when the DESCRIBE statement is executed. |
NumOutputs |
Integer |
Specifies the number of output parameters found in the PREPARE statement. If the database supports output parameter description, PowerBuilder populates this property when the DESCRIBE statement is executed. If the database does not support output parameter description, PowerBuilder populates this property when the FETCH statement is executed. |
InParmType[ ] |
ParmType (enumerated) |
Array containing values specifying the datatype of each input parameter. Values are: TypeBoolean! TypeByte! TypeDate! TypeDateTime! TypeDecimal! TypeDouble! TypeInteger! TypeLong! TypeLongLong! TypeReal! TypeString! TypeTime! TypeUInt! TypeULong! TypeUnknown! |
OutParmType[ ] |
ParmType (enumerated) |
Array containing values specifying the datatype of each output parameter returned. |
DynamicDescriptionArea event |
Occurs |
---|---|
Constructor in PowerScript Reference |
Immediately before the Open event occurs |
Destructor in PowerScript Reference |
Immediately after the Close event occurs |
DynamicDescriptionArea function |
Datatype returned |
Description |
---|---|---|
ClassName in PowerScript Reference |
String |
Returns the name assigned to the object. |
GetContextService in PowerScript Reference |
Integer |
Creates a reference to a context-specific instance of the specified service. |
GetDynamicDate in PowerScript Reference |
Date |
Obtains data of type Date from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicDate when the value of OutParmType is TypeDate! for the value in the array that you want to retrieve. |
GetDynamicDateTime in PowerScript Reference |
DateTime |
Obtains data of type DateTime from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicDateTime when the value of OutParmType is TypeDateTime! for the value in the array that you want to retrieve. |
GetDynamicDecimal in PowerScript Reference |
LongLong |
Obtains numeric data from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicDecimal when the value of OutParmType is TypeDecimal! or TypeLongLong! for the value in the array that you want to retrieve. |
GetDynamicNumber in PowerScript Reference |
Double |
Obtains numeric data from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicNumber when the value of OutParmType is TypeByte!, TypeInteger!, TypeDouble!, TypeLong!, TypeReal!, or TypeBoolean! for the value in the array that you want to retrieve. |
GetDynamicString in PowerScript Reference |
String |
Obtains data of type String from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicString when the value of OutParmType is TypeString! for the value in the array that you want to retrieve. |
GetDynamicTime in PowerScript Reference |
Time |
Obtains data of type Time from the DynamicDescriptionArea after you have executed a dynamic SQL statement. Use GetDynamicTime when the value of OutParmType is TypeTime! for the value in the array that you want to retrieve. |
GetParent in PowerScript Reference |
PowerObject |
Returns a reference to the name of the parent object. |
PostEvent in PowerScript Reference |
Boolean |
Adds the specified event to the end of the message queue for the object. |
SetDynamicParm in PowerScript Reference |
Integer |
Specifies a value for an input parameter in the DynamicDescriptionArea that will be used in the SQL OPEN or EXECUTE statement. Use SetDynamicParm to fill the parameters in the input parameter descriptor array in the DynamicDescriptionArea. |
TriggerEvent in PowerScript Reference |
Integer |
Triggers a specified event in the object and executes the script for the event. |
TypeOf in PowerScript Reference |
Object |
Returns the type of the object. |