GetDynamicTime

Description

Obtains data of type Time 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.GetDynamicTime ( 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.

Returns

Time. Returns the Time data in the output parameter descriptor identified by index in DynamicDescriptionArea. Returns 00:00:00.000000 if an error occurs. If any argument’s value is null, GetDynamicTime returns null.

Usage

Use GetDynamicTime when the value of OutParmType is TypeTime! for the value that you want to retrieve from the array.

Examples

Example 1

These statements set Start to the Time data in the first output parameter descriptor:

Time Start

Start = SQLDA.GetDynamicTime(1)

For an example of retrieving data from the DynamicDescriptionArea, see GetDynamicDate.