Assembly: Db;
The ISQLCommand interface contains properties and methods of the DBMS Command repository object.
ISQLCommand
When a new DBMS command is created, to ensure its correct work, determine the following minimum set of properties in the settings:
To execute the procedure and get results, open the repository object using the IMetabaseObjectDescriptor.Open or IMetabaseObjectDescriptor.OpenWithParam method and cast it to the ISQLCommandInstance interface. If DBMS command is parametric, the parameters set for opening can be created using the IMetabaseObjectParams.CreateEmptyValues method.
Property name | Brief description | |
Database | The Database property determines the database where DBMS command is stored. | |
Text | The Text property determines the text of SQL query for certain DBMS driver. |
Method name | Brief description | |
ClearText | The ClearText method clears the operator of DBMS command. |
See also: