Fetching the Data using TSQLDataSet

Go Up to Using dbExpress

To fetch the data

1. Choose File > New > Other. 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 run time.

     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 the Data to Display
• Fetching the Data
• Executing the Commands
• Accessing Schema Information
• Debugging dbExpress Applications
• Using TSQLTable
• Using TSQLStoredProc
• Using TSQLQuery
• Using dbExpress Datasets