Select Table Screen (Magic xpi 3.x)
The Select Table Screen shows a list of the tables found in the database. These steps explain how to use the screen:
-
From the Available tables field, select a table and click Add. The selected table moves to the Selected table field.
To remove a table from the Selected Tables column, select a table and click Remove.
-
Click Next to display the Select the Columns Screen.
The Select Table Screen contains the following fields:
|
|
|
|
Filters Definition Only
|
This check box lets you select the owner and the tables that will be fetched for the Database wizard's Select Table operation. You can select a specific owner and view all of this owner's tables, or you can select only a subset of these tables. You can also select All to view all tables from all owners, and then select the tables to be used. This may take a long time if there is a large number of tables.
|
|
Available List By Owner
|
This drop-down list enables you to filter the list according to a certain owner, or to display all of the tables. Note that there will also be system tables in the list. Select All to display all available tables.
|
|
Display Field Order
|
The wizard's next screen displays a list of database fields. The Display Field Order drop-down list lets you select the order in which the fields are displayed, either Database order or Alphabetical order.
|
|
Note:
|
You can execute searches for tables and field names in this screen by using Ctrl+F, which opens the Find Table dialog box. Enter the name of the table that you want to find. You can press F3 to find the next matching table. Case sensitive searches can be performed by checking the Case sensitive search check box. Wildcard characters are not supported.
The capability to search for a table's name is available only in the Available Tables section. You can search for field names in both the Source and the Destination sections, and you can search for column names in both the Available Columns and the Selected Columns sections.
|
|
