• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Importing and Connecting > Creating Dynamic SQL Queries

Creating Dynamic SQL Queries

Although the SQL Query Builder is extremely useful for importing, it doesn't include menus for other SQL tasks. When the need arises, you'll find the Execute SQL script step invaluable. Like other script steps, you can use Execute SQL more than once in a single script, allowing you to make several changes to an ODBC database at once.

In this example, we use SQL to give raises to groups of employees in the ODBC database, then transfer the payroll records into our database in FileMaker.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint