The actions for working with a database are collected in this group. In contrast to actions SQL Query и Dataset Loop, all these actions work in one session. At first you have to open a database (DB Open), perform necessary actions and then close the database (DB Close). Thereby, you can execute a complex sequence of actions with a database as a single block.
The actions SQL Query and Dataset Loop open their session for processing query and serve to perform single queries.
The group of actions DataBase works on basis of the mechanism ADO (ActiveX Data Objects) and can work with any database if the system has a proper driver.
DB Exec SQL
DB Begin Transaction
Note: This feature is available for Business license only