Returns the alteration status of the current row.

Defined in

ODBCResultSet

Syntax

status% = odbcResultSet.GetRowStatus

Return value

status%

Integer.
• DB_UNCHANGED (Not changed - values are as fetched)
• DB_ALTERED (Changed by SetValue)
• DB_UPDATED (UpdateRow has occurred)
• DB_DELETED (DeleteRow has occurred)
• DB_NEWROW (AddRow has occurred, but not changed by SetValue)

HasRowChanged reflects row changes that are performed at the data source, which do not affect this status.

Once a row is deleted, SetValue or UpdateRow causes an error, but GetValue is still allowed.

Errors

The result contains no data (DBstsNODA).

Example
See Also

DeleteRow method
Execute method
SetValue method
UpdateRow method

Glossary