Executing SQL to interact with data sources via ODBCIn addition to importing data into a FileMaker Pro database file via ODBC, you can also interact with data sources (such as Microsoft SQL Server and Oracle) using SQL statements through the Execute SQL script step. You can use any SQL statement supported by the data source, such as INSERT, UPDATE, and DELETE.
1.
2. Click New.
3. Add the Execute SQL script step to the script.It appears in the Miscellaneous category.
4.
5. In the Specify SQL dialog box, click Specify.
6. Select your data source and click Continue.
8. Click OK.