|
|
|
ExecuteSQL(Query: String[, Param1: Variant, ..., MemoryTable: Object])
Execute SQL function executes the SQL Query with the parameters specified in Param1, and so on. Returns a memory table containing results of query.
The query string can be a .pfq file name. If the parameter is a pfq file name, you can use the right-click context menu or press Open Source (Ctrl+Enter) on the file name to open the file in the SQL Query Builder.
ExecuteSQL function syntax has these named arguments:
Parameter |
Description |
|---|---|
Query |
Required. The SQL Query code to be executed. This can be a .pfq file name (SQL Query file). |
Param1... |
Optional. Any parameters required by the SQL Query. |
MemoryTable |
Optional. If a Memory Table object is passed in, it will be emptied and the results of the query will be copied to the MemoryTable. |
|
|
|
