Obtains data of type DateTime from the DynamicDescriptionArea after you have executed a dynamic SQL statement.
DynamicDescriptionArea.GetDynamicDateTime ( 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. |
DateTime. Returns the DateTime data
in the output parameter descriptor identified by index in DynamicDescriptionArea.
Returns 1900-01-01 00:00:00.000000
if
an error occurs. If any argument’s value is null, GetDynamicDateTime returns null.
Use GetDynamicDateTime when the value of OutParmType is TypeDateTime! for the value that you want to retrieve from the array.
To test for the error value, you must use the DateTime function to construct the value to which you want to compare the returned value. PowerBuilder does not support DateTime literals.
These statements set SystemDateTime to the DateTime data in the second output parameter descriptor:
DateTime SystemDateTime
SystemDateTime = SQLDA.GetDynamicDateTime(2)
IF SystemDateTime = &
DateTime(1900-01-01, 00:00:00) THEN
... // Error handling
END IF
For an example of retrieving data from the DynamicDescriptionArea, see GetDynamicDate.