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:
 •
 •
 •
Notes on stored queries:
 •
When you execute a stored query, error checking is performed at runtime only. Use Get(LastError) function, and then use Get(LastODBCError) function to return the last readable error string that is generated by the ODBC driver.
 •
 •
 •