DBS_* actions for table access

The group of actions DBS_READ, DBS_DELETE, DBS_INSERT, DBS_UPDATE are intended to work with a table. They are other than the actions DB_READ, DB_DELETE, DB_INSERT, DB_UPDATE, because they don't require opening a table before (calling the action DB_CONNECT).

All parameters of the DBS_* actions are identical with the parameters of the DB_* actions, except the first parameter. The first parameter of the actions DB_* is always the handle to a table that is acquired when opening the table using the DB_CONNECT action. For the DB_* actions, this parameter is substituted by the reference to a Database table type object.

An advantage of the DBS_* actions when working with a table is the possibility to leave out closing and opening the table (a shorter declaration). On the other hand, a disadvantage is in the speed. Every calling a DBS_*action, within the frame of its handler in the process D2000 DBManager, results in the need to open and then close the database (it may be a time-consuming operation) and represents, in terms of databases, relatively a nonstandard method. This method can be eliminated to a certain extent by an appropriate setting of the optimization.
The need to open and close the database may be avoided in the scope of transaction processing, so that the command is followed by the parameter

TRANS
_transHandle_Int, where _transHandle_Int is the identifier of the Connection to a database.

Related pages:

Napíšte komentár