Updates the current row, if changed, to the database.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.UpdateRow

Return value

• True indicates that the row was updated successfully.
• False indicates that the row has been altered or locked by another user or process, or the database is read-only.

Use ReadOnly to determine if the database is read-only, in which case it cannot be updated.

UpdateRow leaves you on the current row. If you perform an AddRow followed by an UpdateRow, you remain on the added row.

UpdateRow may fail when the result set includes columns with Image or Rich Text data types or when rows are not identified uniquely. To avoid these failures, see "Working with data retrieved from an external database" in LotusScript Coding Guidelines."

Errors

Read only. Data cannot be updated or deleted (DBstsRDON)

The row has previously been deleted (DBstsROWD)

Update or Delete cannot locate a unique row (DBstsNUNQ)

No changes in row (DBstsRUNC)

Events

BeforeUpdateRow

AfterUpdateRow

Example
See Also

AddRow method
Close method
GetRowStatus method
HasRowChanged method
IsSupported method (in ODBCConnection)
ReadOnly property
SetValue method

Glossary