DBMS Command

To start a DBMS command, execute one of the operations:

• In the web application:

• Select the Open item in the object's context menu.

• Select the Open in a New Tab item in the object's context menu.

• Select the Open in a New Window item in the object's context menu.

• Double-click the object.

• In the desktop application:

• Click the Open button in the Open group on the Home ribbon tab.

• Click the Open > In Default Tool button in the Open group on the Home ribbon tab.

• Select the Open item in the object's context menu.

• Double-click the object.

The result of running a DBMS command is the number of processed records.

NOTE. The DBMS command is started within the transaction created by the platform. This should be taken into account in the script that uses custom transactions.

To edit DBMS command, select the corresponding object in the object navigator and execute one of the operations:

• In the web application:

1. Open the DBMS command for edit.

2. Click the Settings button.

• In the desktop application:

• Click the Edit button on the Home ribbon tab.

• Select the Edit item in the command's context menu.

• Press F4.

After executing one of the operations the DBMS command wizard opens. Determine settings on corresponding pages of the wizard.

If the repository connected to version control system, the DBMS command can be added to the system to control changes in its version. To do this, select the Add to VCS context menu item for the DBMS command in the object navigator. After adding the object to VCS server one can track its changes. Version control system stores DBMS command text and parameter settings. For details about working with objects added to version control system, see the Developing Applications in a Team section.

To change DBMS command text, use the Query Console panel.

The panel displays the DBMS driver in use and contains the command text specified on its creation. Create a new text in the SQL language according to the syntax that is set for the DBMS driver.

NOTE. On entering the command text, take into account differences of SQL language that may appear in different DBMS versions.

To set the specified command text for all DBMS, click the Apply for All DBMS button. After this the action confirmation dialog box opens. Confirmation is required if at least one driver differs from the current one, has non-empty query text.

To execute the command, click the Execute Query button. The result of running a DBMS command is the number of processed records.

NOTE. The DBMS command is started within the transaction created by the platform. This should be taken into account in the script that uses custom transactions.

To rename DBMS command:

1. Click on the command name in the Basic Settings area. The name opens in the edit mode.

2. Make necessary changes.

3. Click outside the command name.

To save DBMS command:

• Click the Save button.

• Confirm custom operation in the information window when going to the object navigator/DBMS command wizard.