RAD Studio |  |

Fetching Records Asynchronously
See Also
Collapse All

Unlike other datasets, ADO datasets can fetch their data asynchronously. This allows your application to continue performing other tasks while the dataset populates itself with data from the data store.

To control whether the dataset fetches data asynchronously, if it fetches data at all, use the ExecuteOptions property. ExecuteOptions governs how the dataset fetches its records when you call Open or set Active to True. If the dataset represents a query or stored procedure that does not return any records, ExecuteOptions governs how the query or stored procedure is executed when you call ExecSQL or ExecProc.

ExecuteOptions is a set that includes zero or more of the following values:

Execution options for ADO datasets

Execute Option | Meaning
eoAsyncExecute | The command or data fetch operation is executed asynchronously.
eoAsyncFetch | The dataset first fetches the number of records specified by the CacheSize property synchronously, then fetches any remaining rows asynchronously.
eoAsyncFetchNonBlocking | Asynchronous data fetches or command execution do not block the current thread of execution.
eoExecuteNoRecords | A command or stored procedure that does not return data. If any rows are retrieved, they are discarded and not returned.

See Also

Connecting an ADO Dataset to a Data Store

Working with Record Sets

Using Batch Updates

Loading Data from and Saving Data to Files

Filtering Records Based On Bookmarks

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!