Contents Index Topic Contents

Refresh Method

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

Syntax

DataControl.Refresh

Part	Description
DataControl	An object variable that represents an RDS.DataControl object.

Applies To

RDS.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 RDS.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 periodically when you work with data. If you retrieve data, and then leave it on your client machine for a while, it is likely to become out of date. It's possible that any changes you make will fail, because someone else might have changed the record and submitted changes before you.

Example

See Also

CancelUpdate Method, SubmitChanges Method, Address Book Command Buttons, Using RDS.DataControl to Pass Updated Disconnected Recordset Objects Back to the Middle Tier

---

 Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.