Storing an SQL query in a field
You can store an
SQL query in a text field for use with the
Import Records script step or
Execute SQL script step.
To store a query in a field, do one of the following:
•Type a query directly into a field.
•Use the SQL Query builder to construct a query, then copy and paste it into a field.
Notes
•The SQL Query builder validates queries for use only with FileMaker Pro.
•You can store and execute a different query in each record of your
database file.
•You can store a query in a global field to guarantee the same query is executed regardless of which record you are on.