Selecting Data for the Database Viewer

The Details view displays the source of the data displayed in the Database Viewer, and the SQL (Structured Query Language) expression used to select the data. Use the Details view to modify the data displayed in the Database Viewer. Click Details in the Database Viewer window to display the view.

The Database Viewer contains the following information:

    DSN Name The Data Source Name of the Site database.

    User ID The name of the account used to access the DSN.

    User Password The password of the account used to access the DSN.

    SQL Code The SQL expression that selected the data currently displayed by the Database Viewer. To specify the records to be shown in the Viewer, edit the SQL code, or click SQLWizard to open SQLWizard and create a new expression using a natural language interface.

To apply SQL changes to the Database Viewer, click Execute SQL, or press the F5 key.

Related Topics

Creating SQL Statements

Using SQLWizard