Purpose
Refreshes the values in the current rowset buffers.
If changes have occurred to the current row in the underlying database, calling the Refresh method will update the local cursor and propagate any relevant changes to bound controls.
If you have modified the current values in the rowset buffers, calling Refresh will get a new copy of the original row from the database and overwrite any changes.
Syntax
DBStatement.Refresh
Compliance:
Level 2
Example
Sub Click()
MsgBox("Update the current record?",FCYesNo, "Update")
If MsgBoxResponse = FCYes Then
MyStmt.Update 'Update the current record
Else
MyStmt.Refresh 'Discard changes and return original values
End If
End Sub
|