Executes the query and stores the results as a table on the database. Items on the Request line become the column headings of the new table, and you can append new columns to the table and query it as needed.
The Interactive Reporting database connection file and database to which you are connecting determine whether or not you can use this feature. You must also have Create and Insert privileges on the database in order to process to a database table. |
Expression.ProcessToTable (TableName As String, bqProcessType As String, [optional] Grantee As String).
Grantee is the person to whom access is granted—either PUBLIC, a single user id, or list user identifications that are comma delimited. Grantee is optional because it depends on whether a user is creating a table or appending to an existing table. |
An expression that returns a QuerySection object
The BqProcessType is constant group contains the bqProcessCreateTable and bqProcessAppendToTable values.
In this example, the results are stored in a new table entitled MyTable:
ActiveDocument.Sections["Query"].ProcessToTable(‘MyTable’, bqProcessCreateTable, ‘Public’)
In this example, the results are appended to “MyTable”:
ActiveDocument.Sections["Query"].ProcessToTable(‘MyTable’, bqProcessAppendToTable, ‘Public’)