Automating ODBC import using the Import Records script step
Because accessing ODBC data sources is a task you might repeat frequently, you can create a script with the Import Records script step that automates ODBC import. Some script step options behave differently than when used with other file formats.
The Specify data source option stores:
 •
 •
 •
the SQL query to be executed against the data source
For more information, see Import Records script step.
When you choose an ODBC data source in the Import Records script step, the Specify ODBC SQL Query dialog box opens. You can do any of the following:
 •
 •
 •
Notes
 •
To save the user name and password, select Save user name and password in the ODBC Enter Password dialog box.
 •
The Perform without dialog option hides all dialog boxes during an ODBC import.
 •
The Specify import order option stores the field order in the Import Field Mapping dialog box, similar to other scripted imports.
 •
The Set Error Capture script step suppresses ODBC alerts.
 •
The ODBC import feature saves the data source name, user ID and password, and the SQL query from the previous ODBC import. Keep this in mind when selecting the Specify import order or Specify data source options.
 •
 •
 •
 •
If you use the Import Records script step to import ODBC data that contains Unicode strings, your ODBC driver must support Unicode. Otherwise, the results may be inconsistent.
 •
ODBC import, the Execute SQL script step, and external SQL data sources are not supported in runtime solutions created with FileMaker Pro Advanced.