DB_REFRESH_TABLE action


Function
The action forces refreshing of the displayed data for user's views in the D2000 HI process (e.g. displayer of Browser type).
Declaration
 DB_REFRESH_TABLE
dbObjIdent[, retCodeIdent_Int] [ON procIdent]
Parameters
dbObjIdentinReference to an object of Database table type.
retCodeIdent_IntoutIdentifier - return code (optional parameter).
procIdentin Identifier of D2000 HI process.
Return code
The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Description
The action should be used, if data in table are being changed and it is necessary to display them for user's views (displayer of Browser type).

If retCodeIdent_Int is not given, the action makes a difference as a request to refresh data without waiting for a result (or termination of the refresh).

If this parameter (return code) is entered, the action will be terminated as soon as all Browser devices are terminated (procIdent must be set) in all opened processes D2000 HI.

If procIdent is entered, only a defined D2000 HI process will be refreshed, if not, all opened D2000 HI processes will be refreshed.

Note
If data in a table was modified by actions DB(S)_INSERT, DB(S)_UPDATE, DB(S)_INSUPD, DB(S)_DELETE, PG_INSERT, PG_UPDATE, PG_DELETE (in non-transactional mode), by action DB_TRANS_COMMIT (which commits at least one of previously mentioned actions) or directly by editing in Browser, then the D2000 DBManager process automatically refreshes this table's data in all Browsers, that have opened this table. Therefore it's not necessary to call DB_REFRESH_TABLE. Action DB_REFRESH_TABLE should be called to refresh data only if the data in a table was modified by  means different from above specified actions (e.g. by calling stored procedure, by action SQL_EXEC_DIRECT, etc.).

Related pages:

Napíšte komentár