PRB: Recordset Navbar Only Returns First, Second, and Last Records (192246)

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.

MORE INFORMATION

Steps to Reproduce Behavior

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