Small company logo:
   History
 
Advertising banner:
 
 Statement.Refresh
Home • Help • Customization Tools • FCAS • Language Reference • Statement.Refresh
 
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