Indicates whether values in the current row have changed in the data source; that is, indicates whether values differ from what was fetched into the result set.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.HasRowChanged

Return value

• True indicates that values in the database changed since they were last fetched.
• False indicates that values are not altered.

Result set values changed by SetValue are separate and do not affect this method; use GetRowStatus to find changes made within the program. HasRowChanged indicates changes made by other programs.

This statement can 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

Result set contains no data (DBstsNODA)

Cannot locate a unique row (DBstsNUNQ)

Example
See Also

UpdateRow method

Glossary