Language Reference Guide : System Classes : QueryObject Class : DBUpdate Method
 
Share this page          
DBUpdate Method
The DBUpdate method performs updates on database tables with columns mapped to variables or fields specified for update.
This method has the following syntax:
integer = QueryObject.DBUpdate([rownumber = integer]
          [, isrepeated = integer]
          [, zerorowsiserror = integer][, maxrows = integer])
This method has the following parameters:
rownumber
Specifies the row affected by the operation. This parameter is needed only if the query is opened in QY_CACHE mode.
Default: the current row
isrepeated
Specifies whether the query is repeated. Valid values are TRUE (to specify a repeat query), or FALSE.
Default: FALSE
zerorowsiserror
Specifies whether an error is generated for zero rows to be updated. Valid values are TRUE or FALSE.
Default: FALSE
maxrows
Specifies the maximum number of rows that can be updated before generating an error. If this parameter is greater than zero, it specifies that updating of more than this number of rows is an error.
Default: 0
If the DBUpdate method is successful, it returns ER_OK. If it is not successful, it returns a non-zero value. Descriptions of system constant values and their numeric equivalents are listed in Error Codes).