Refresh Method (Remote Data)

       

Closes and rebuilds the rdoResultset object created by a RemoteData control or refreshes the members of the collections in the Applies To list.

Syntax

object.Refresh

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Remarks

You can use the Refresh method on a RemoteData control to close and reopen the rdoResultset if the properties that describe the result set have changed. When you use the Refresh method, the properties and current row position is reset to the state set when the query was first run.

Once the Refresh method has been executed against the RemoteData control, all stored rdoResultset bookmarks are invalid.

If both the BOF and EOF property settings of the rdoResultset object are True, or the RowCount property is set to 0 after you use the Refresh method, the query didn’t return any rows and the new rdoResultset contains no data.

Use the Refresh method in multi-user environments in which the database schema is subject to change to retrieve current table definitions. Using the Refresh method on an rdoTables collection fetches table names from the base tables in the database. Using Refresh on a specific rdoTable object’s rdoColumns collection fetches the table structures including column names and data types from the base tables.

Note   Before you can use the name of a base table in the name argument of the OpenResultset method, you must first use the Refresh method against the rdoTables collection to populate it. You can also populate the rdoTables collection by referencing one of its members by its ordinal number. For example, referencing rdoTables(0) will populate the entire collection.