Refresh Method

Requeries the ODBC data source specified in the Connect property and updates the query results.

Syntax

RDSIE3.DataControl.Refresh

Part	Description

RDSIE3.DataControl	An object variable that represents an RDSIE3.DataControl object.

Applies To

RDSIE3.DataControl

Remarks

You must set the Connect, Server, and SQL properties before you use the Refresh method. All data-bound controls on the form associated with an RDSIE3.DataControl object will reflect the new set of records. Any pre-existing Recordset object is released, and any unsaved changes are discarded. The Refresh method automatically makes the first record the current record.

It's a good idea to call the Refresh method when you work with data. If you get data, and then let it sit on your client machine for a while, it is more likely to become out of date, and it's possible your changes won't go through because someone else would have changed the record before you.

Example