User manual

Using ODBC with FileMaker Pro 15-13
Use the Sales Reports database to view reports of your data.
To view a summary report of total sales for each salesperson, click
the Reports button, then the By Salesperson button.
Automating ODBC connections
Because accessing ODBC data sources is a task that’s frequently
repeated, you might want to create a script with the Import Records
script step that automatically finds the data source. Since
FileMaker Pro interacts with an ODBC driver, however, some
options behave differently than when used with other file formats.
The Specify File option stores:
1 the data source name
1 the user ID and password (optional)
1 the SQL query to be executed against the data source
Keep these points in mind:
1 To save the user name and password, 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 haven’t specified a data
source to import from, you must manually select ODBC in the Open
File dialog box while performing the import script.
1 The Restore import order ScriptMaker option stores the field order
in the Import Field Mapping dialog box, similar to other scripted
imports.
1 The Set Error Capture ScriptMaker step suppresses all ODBC error
messages and alerts that might occur during an ODBC import.
1 Each script can save one set of ODBC import options. To access
multiple ODBC data sources or to automate multiple queries, you
must create a separate script.
Note 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 Restore import order or Specify
File options.
Tip To automate the interaction across multiple applications, explore
the ActiveX functionality (Windows only). For more information,
see chapter 10, “Creating scripts to automate tasks.”
SQL query using all three clauses: SELECT, WHERE, and ORDER BY