How You Can Update Data with a Query Object
To update underlying database tables whose columns have been specified for update and mapped to the Columns array attribute, use QueryObject's DBUpdate method.
This method takes the following parameters:
RowNumber
Specifies the row of the cache updated by the operation (used only if opened in QY_CACHE mode)
Default: the current row
IsRepeated
Set to TRUE if repeat queries are to be used
Default: FALSE
ZeroRowsIsError
If set to TRUE, a zero row result indicates an error; otherwise OK is returned
Default: FALSE
MaxRows
If nonzero, specifies the maximum number of rows that may be affected by the query. If more rows are affected than is specified by MaxRows, returns an error.
Default: zero (unlimited)