DBGetTime

Description

Specifies the number of seconds PocketBuilder waits for a response from the DBMS when you retrieve rows in a DataWindow object 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), PocketBuilder 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

ODBC

Syntax

DBGetTime = value

Parameter	Description
value	The number of seconds PocketBuilder waits for a DBMS response while waiting to retrieve the first row of a DataWindow object or query

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

Examples

Example 1

To enable asynchronous operation and set the DBGetTime parameter to 20 seconds:

Database profile Select the Asynchronous check box and type 20 in the Number Of Seconds To Wait box on the Transaction tab in the Database Profile Setup dialog box.
PocketBuilder application script Type the following in a PocketBuilder application script:
```
SQLCA.dbParm = "Async = 1, DBGetTime = 20"
```