Description Usage Arguments Value
View source: R/ExecutePreparedSQL.R
This method executes a previously created parameterized SQL query.
1 2 3 | r2hpcc.ExecutePreparedSQL2(conn, workunitId, variables = NULL,
supressResults = 0, suppressXMLSchema = 1, timeout = -1,
resultWindowStart = 0, resultWindowCount = 0)
|
conn |
- HPCC connection information |
workunitId |
- The Workunit ID (WUID) |
variables |
- List of pairs(name, value) to replace placeholders in prepared SQL |
supressResults |
- If set to 1 or true, query results are not included in response |
suppressXMLSchema |
- If set to 1 or true, the query result schema is not included in response |
timeout |
- Timeout value in milliseconds. Use -1 for no timeout |
resultWindowStart |
- For use with page-loading, the starting record to return |
resultWindowCount |
- For use with page-loading, the number of records to include from the ResultWindowStart |
Workunit details
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.