SetDbCommand

Syntax

SetDbCommandResult SetDbCommand(DbCommandId tDbCommand, SetDbCommandArg tArg)

Parameters

tDbCommand. SQL repository object moniker.

tArg. Parameters of metadata getting.

Description

The SetDbCommand operation changes metadata of SQL object of the repository.

Comments

To execute the operation, in the tDbCommand field specify the opened SQL object instance moniker, and in the tArg field specify changing parameters. The moniker can be obtained on executing the OpenDbCommand operation. In the tArg.pattern field specify the pattern that will be used to make changes, and in the tArg.meta field specify the updated metadata. To save changed metadata after the SetDbCommand operation, execute the SaveObject or SaveObjectAs operation.

The SetDbCommand operation is also used to set parameter values on executing parametric SQL objects. Parameter values are specified in the tArg.meta.openArgs collection, the tArg.pattern.openArgs field must also be determined. Along with input parameter values, tArg.meta.openArgs must also contain parameters with the Output/Function Result value. Values for these parameters are not set, they are calculated on executing the corresponding SQL object. To execute the SQL object within the SetDbCommand operation, determine the tArg.metaGet.rows/tArg.metaGet.exec field.

The SetDbCommand operation results in the moniker of changed SQL object and requested metadata, if the tArg.metaGet pattern was specified on executing the operation.

Example

Various methods of using the operation are given in the following examples:

Example name

Changing SQL Object Parameters

Executing Parametric SQL Object