Requery Method Not Available on PassThrough Queries (129925)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
This article was previously published under Q129925 SUMMARY
Visual Basic version 4.0 adds the Requery method for the RecordSet object.
This method updates the data in a Recordset object by re-executing the
query on which the object is based. When you use Requery, all changes made
to the data in the underlying table by other users are displayed in the
Recordset, and the first record in the Recordset becomes the current
record. This method is not available for RecordSets created using the
OpenRecordset method with the dbSQLPassthrough option.
CAUSE
The Requery method requires that column IDs are maintained and that column
datatypes and names are the same. For passthrough queries Visual Basic
passes the query through to the ODBC database without parsing it and has no
way of knowing that these values will be maintained, so it disallows
requery. The same is true for Crosstab queries without fixed column lists.
STATUS
This behavior is by design.
Modification Type: | Major | Last Reviewed: | 12/9/2003 |
---|
Keywords: | kbDatabase KB129925 |
---|
|