LOTUS CONNECTORS


UpdateRow method
Example

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

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.UpdateRow

Return value


Usage

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