Database data Lookups

Previous  Top  Next

You can get database data from the current or an another database by using table, view or SQL statement lookups.

 

Table or View Lookup

The Table and View Lookup properties are very similar, the only difference is the list of available tables or views. Below is an example screenshot.

 

The wizard will default to [current database] from which you can select a table or view. If you select another of the available databases, connecting to it will be attempted and if successful, the list of available tables or views will list the objects from the selected database.

 

The Lookup will get the same name as the selected table or view.

 

Table Lookup properties

 

After selecting a table or view, the columns will be listed and you can select which columns you would like to include when loading the data. An optional ORDER BY SQL-clause can be created by using the edit box for that, as well as a WHERE clause can be entered.

 

SQL Statement Lookup

The SQL Statement lookup properties are a bit different as you have to enter an SQL statement that returns a result set.

 

The wizard will default to [current database] for which you can enter an SQL statement. If you select another of the available databases, connecting to it will be attempted and if successful, you can enter an SQL statement based on the objects in that particular database.

 

You need to enter a "name" for the Lookup yourself.

 

SQL Statement Lookup properties

 

After entering an SQL statement, use the green arrow button to retrieve the result set columns for the given SQL statement and select the columns you would like to be included in the Lookup definition.