SQLData object DataSheet tab

Use the DataSheet tab to view data stored in the connected SQL Server database table.

The database preview allows you to enter a configurable SQL Server query to filter the preview of the database during configuration. You can use this SQL Server query to test your free format run-time query string.

Rows can be deleted from the database via the database preview.

Options are as follows.

Database Query

A valid SQL query. The result of query is written to the Data list view.

Refresh

Executes the database query and loads the selected database records into the Data list view. If the Database Query box is empty, all database records are loaded into the Data list view.

Number of Records

The current number of records in the Data list view

Data

Displays the contents of the database query after a refresh. If the Database Query is blank, the refresh returns the entire contents of the database.