SQL Queries can by created using the wizard, or manually input in a character string.
The hModifyFile mode
constant can be set when executing a query, if property SQLLIVE is set in
connection level extended info (Value 1 or 3).
In this case, files involved in the query are updated when the query result is
modified.
By default, additional queries are prepared to be able to change records order in tables and allow the use of magnifiers in tables. This feature can be disabled with property SQLIDX in connection extended info.
Area fields cannot be used with SQL queries.
Filters on queries are not supported.