Microsoft KB Archive/192246

= PRB: Recordset Navbar Only Returns First, Second, and Last Records =

Article ID: 192246

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q192246



SYMPTOMS
When navigating a Recordset with the Recordset Design-Time Control (DTC), you receive only the first, second, and last records of your result set. The Recordset Cache option "no cache" has been specified in the properties of the Recordset DTC.



CAUSE
The Recordset Cache options determine how much of the recordset is maintained in memory, and which record you move to when the recordset is opened. You can use these to tune browser performance when opening recordsets.

When the No Cache option is selected the recordset is not maintained in memory and you will not be able to navigate the recordset.



RESOLUTION
Under the Recordset Cache options for the Recordset DTC instead of selecting "no cache," you can specify any of the following cache options:
 * Preserve Bookmark in page Choose this setting if you want to move to the record with a bookmark when the recordset is opened on this page. When you move to another page, this setting no longer applies.
 * Preserve Bookmark in Session state Choose this setting if you want to move to the record with a bookmark whenever this recordset is opened during this browser session.
 * Preserve Recordset in Session state Choose this setting if you want the entire recordset to be loaded into memory when this recordset is first opened during this browser session. This setting is useful if you will be accessing this recordset's data frequently during a particular session.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) Open a project with a data connection.
 * 2) Insert a Recordset DTC called Recordset1, and bind it to a table; for example, use the Shippers table in Northwind)
 * 3) Under the Implementation tab of the Properties of Recordset1, set the Recordset Cache to "No cache."
 * 4) Insert a Textbox DTC and bind it to Recordset1 and a field in the table.
 * 5) Insert a Recordset Navbar DTC and bind to Recordset1.
 * 6) View the page in your Web browser and navigate the recordset with the Recordset Navbar controls.

Additional query words: - Written by the Developer Support Internet ASP Team kbVisID: Visual Interdev kbVisID600: Ver. 6.0 kbVisID600bug: bug

Keywords: kbide kbprb kbctrl KB192246

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.