Linking to a table automatically

Topic group

The easiest way to use table data in a form or report is to drag the table from the Navigator onto the form or report design surface.

For BDE-standard tables that you’re accessing without a BDE alias, this creates a Query object.

For SQL, ODBC, and other tables you’re accessing through a BDE alias, this automatically creates both the Database object, which is required to connect to the database, and the Query object for the table.

The SQL and rowset properties of the Query object, and the dataBaseName property of the Database object are both set automatically, and the active property of both objects is set to true. The link is complete, and fields of the table are available from the Field palette.

The SQL statement in the SQL property selects all the fields of the table. You can modify this statement in the Inspector. Click the tool beside the SQL property.