Installation and New Features Guide (Windows)

ODBC import with FileMaker Pro 5-21
Using ODBC import with ScriptMaker
As with other import script steps, you can create an ODBC script that
hides all dialog boxes during an ODBC import. Because FileMaker Pro
interacts with an ODBC driver, however, some options behave
differently than when used with other scripted imports:
1 The Restore import order option stores the field order in the Import
Field Mapping dialog box, similar to other scripted imports.
1 The Specify File option stores the path to the data source, the user ID and
password, and the SQL query to be executed against the data source.
To save the user name and password, you must also select the Save
user name and password checkbox in the ODBC Enter Password
dialog box.
1 The Perform without dialog option hides all dialog boxes encountered
during an ODBC import.
If you select this option but you have not specified a file, you will
need to manually select ODBC in the Open File dialog box while
performing the import script.
Note The ODBC import feature saves the complete data source path
information, user ID and password, and SQL query from the previous
ODBC import. Keep this in mind when selecting the Restore import order
or Specify File options.
In addition, the Set Error Capture ScriptMaker step will suppress all
ODBC errors and alerts that might occur during an ODBC import.
Choose a report in the Sales Reports database