RAD Studio |  |

Fetching the Data using TSQLDataSet
See Also
Collapse All
To fetch the data

1. Choose FileNewOther. The New Items dialog appears.
2. In the New Items dialog, select Delphi Projects and double-click VCL Forms Application. The Windows Designer displays.
3. From the dbExpress category of the Tool Palette, drag a TSQLDataSet component to the form.
4. To fetch the data for a unidirectional dataset, do one of the following:
   - In the Object Inspector, set the Active property to True.
   - Call the Open method at runtime.
     Tip: Use GetMetadata property to selectively fetch metadata on a database object. Set GetMetadata to False if you are fetching a dataset for read-only purposes.
5. Set its Prepared property to True to prepare the dataset explicitly.
6. Call the NextRecordSet method to fetch multiple sets of records.

Note: NextRecordSet returns a newly created TCustomSQLDataSet component that provides access to the next set of records. That is, the first time you call NextRecordSet, it returns a dataset for the second set of records. Calling NextRecordSet returns a third dataset, and so on, until there are no more sets of records. When there are no additional datasets, NextRecordSet does not return anything.
See Also

dbExpress Components

Specifying Display Data

Fetching the Data

Executing the Commands

Accessing Schema Information

Debugging dbExpress Applications

Using TSQLTable

Using TSQLStoredProc

Using TSQLQuery

Using Unidirectional Datasets

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