ProcessRunSqlQuery

Member of namespace

Maintenance Manager

Syntax

bool ProcessRunSqlQuery ()

Parameters

None.

Returns

True if the query is successful. Otherwise, False.

Level

Any level.

Details

Performs the SQL select query using a query previously built using Maintenance Manager actions. The QuerySet actions need to have been previously called to create the query. The resulting record set is retained in memory and can be acted upon by using other actions.

The action LogWriteRecordSet can be used to write out the recordset, usually for debugging, as well as LogWriteSQLQuery which will output the constructed query. QueryClear can be used to remove any existing query settings.

Example:

QuerySetStation("1")
QuerySetJobID("!Demo Job")
ProcessRunSqlQuery("")           

This example obtains results that include all batches, except for Demo Job, that have been run on station "1".