Using TSQLTable

Go Up to Using dbExpress

TSQLTable represents a database table that is accessed using dbExpress. TSQLTable generates a query to fetch all the rows and columns in a table you specify. You can add a TSQLTable component to a form at designtime, or create one dynamically at run time.

To use TSQLTable

1. Open File > New > Windows VCL Application - Delphi
2. From the dbExpress category of the Tool Palette, drag a TSQLTable component to the form.
3. In the Object Inspector, set its Name property to a unique value appropriate to your application.
4. Set the SQLConnection property.
5. Set the TableName property to the name of the table in the database.
6. Add a data source component to the form.
7. Set the DataSet property of the data source component to the the name of the dataset.

See Also

• dbExpress Components
• Configuring TSQL Connection
• Specifying the Data to Display using TSQLDataSet
• Fetching the Data
• Executing the Commands using TSQLDataSet
• Accessing Schema Information
• Using TSQLStoredProc (Procedure)
• Using TSQLQuery
• Using TSimpleDataSet
• Using dbExpress Datasets