DBGetTime

Description

Specifies the number of seconds InfoMaker waits for a response from the DBMS when you retrieve rows in a DataWindow object, form, or query. When you set the Async parameter to 1 to enable asynchronous operation, you can also set the DBGetTime parameter for those DBMSs that support this parameter.

If DBGetTime is set to 0 (the default), InfoMaker waits indefinitely for a DBMS response (the request never times out). If the DBGetTime value expires before the first row is retrieved, your request is automatically canceled.

Applies to

ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
I10 Informix
IN9 Informix
JDB JDBC
ODBC (if driver and back-end DBMS support this feature)
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g

Syntax

DBGetTime=value

Parameter	Description
value	The number of seconds InfoMaker waits for a DBMS response while waiting to retrieve the first row of a report or form.

Default

DBGetTime=0

Usage

Requirements for using DBGetTime To use the DBGetTime parameter, you must do both of the following:

Set the Async parameter to 1 to enable asynchronous operation, as shown in the Examples.
Code a RetrieveRow event for a DataWindow object or report.

Examples

Example 1

To enable asynchronous operation and set the DBGetTime parameter to 20 seconds, select the Asynchronous check box and type 20 in the Number Of Seconds To Wait box on the Transaction page in the Database Profile Setup dialog box.