This section discusses:
Meta-SQL element types.
Meta-SQL expands to platform-specific SQL substrings, causes another function to be called, or substitutes a value. Meta-SQL constructs are used in functions that pass SQL strings, such as the following:
Scroll buffer functions (ScrollSelect and its relatives).
Application Designer dynamic views and SQL views.
Some Rowset class methods (Select, SelectNew, Fill, and so on.).
The SQL class.
Application Engine programs.
Some Record class methods (Insert, Update, and so on.).
Meta-SQL Element Types
There are three types of meta-SQL elements:
Constructs are a direct substitution of a value, and help to build or modify a SQL statement.
Examples include %Bind, %InsertSelect, and %List.
Functions perform actions or cause another function to be called.
Examples include %ClearCursor, %Execute, and %ExecuteEdits.
Meta-variables enable substitution of text within SQL statements.
Examples include %AsOfDate, %Comma, and %JobInstance.