Please enable JavaScript to view this site.

Altova MobileTogether Designer

Databases

Selecting DB Objects as Data Sources

Scroll Home Prev Top Next More

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.

 

Selecting a table as a data sources

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.

Click to expand/collapse

Note:Only one table can be selected at a time as a data source.

 

Using a SELECT statement

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.

Click to expand/collapse

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

Click to expand/collapse

5.Click OK to add the data source to the page sources.

 

© 2019 Altova GmbH