QuerySetGeneric

Builds an SQL query using the provided column name and value.

Member of namespace

Maintenance Manager

Syntax

bool QuerySetGeneric (string column, string value)

Parameters

column: Type: string
value: Type: string

Parameters

column: Column in the database table to query. Smart parameters are supported.
value: Value to match within the specified column. Smart parameters are supported.

Returns

True if the query has been successfully set. It does not mean the query has been performed. Otherwise, False.

Level

Any level.

Details

Allows building of a query where the column and value of the tmbatch, queue or qstats table are explicitly specified.

Any wild card specified in the value parameter would need to be appropriate for your target database. The column value is not validated until the query is run using ProcessRunSqlQuery.

Example:

QuerySetGeneric("pb_userid", "admin")
ProcessRunSqlQuery("")