After connecting to a DB, the Insert Database Objects dialog (screenshot below) is displayed. In this dialog, you can select the DB objects you wish to add as a data source, either by selecting a table or by using a SELECT statement.
In the screenshot below, the MobileCockpit_Sales table has been selected. Click Show Preview to display the rows of the selected table in the Preview pane at the bottom of the dialog.
|Note:||Only one table can be selected at a time as a data source.|
To select the data source by using a SELECT statement, do the following:
1.In the Insert Database Objects dialog (screenshot above), click Add/Edit SELECT Statement. This displays the Enter a SQL SELECT Statement dialog (screenshot below).
2.Enter the SELECT statement you want and give the statement a name. In the screenshot below, we select, with the WHERE clause, rows that have id=20. We give the statement a name of Vienna Offices.
3.Click Add SELECT Statement to add the statement. The SELECT statement appears in the Source pane (see screenshot below).
4.Click Show Preview to display the rows of the selected table in the Preview pane
5.Click OK to add the data source to the page sources.