Database Wizard (Magic xpi 4.6)
You can use the Database Wizard to define a new database.
You access the Database Wizard from the Database Properties pane by clicking in the Wizard property. You can also access the last screen of the Database Wizard by clicking in the SQL Statement property. Here, you can manually change the SQL statement, overwriting anything already entered in the SQL Statement property.
The steps to take throughout the wizard differ depending on the options you select in each screen. The following topics describe the wizard screens:
Select Tables Screen
Select Columns Screen
WHERE Clause and Order By Screen
Join Statements Screen
Wizard Summary Screen
How Do I Create an SQL Statement Without Using the Data Mapper's Database Wizard?