Microsoft KB Archive/190582

{| The information in this article applies to:
 * width="100%"|
 * Microsoft Visual InterDev, version 1.0

SYMPTOMS
When filtered, recordsets that were created by the DataForm wizard do not change when moving through different pages of the recordset. Instead, the data is repeated from page to page.

CAUSE
The DataForm wizard code was designed to work with Activex Data Objects (ADO) 1.0. If you have installed Microsoft Data Access Components (MDAC) 1.5B or MDAC 1.5C (which is included in Internet Information Server 4.0), the DataForm wizard code does not implement the filter property correctly.

This is because the DataForm wizard code uses server side cursors, and with ADO 1.5 the filter property does not work correctly when using server side cursors.

RESOLUTION
The best solution to this problem is to not use the filter property of ADO 1.5. Instead the filter should invoke a requery of the database, as discussed in the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q167819 TITLE    : HOWTO: Convert Filtering in DataForm Wizard to Requery Model

STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base, as it becomes available. This issue may be fixed in the new release of ADO, which is ADO 2.0.

Steps to Reproduce Behavior

 * 1) Create a new Web project using the Web Project Wizard.
 * 2) After the Web project is created, right-click the Global.asa file.
 * 3) Select Add Data Connection.
 * 4) Click AdvWorks under the Machine Data Source tab.
 * 5) Change the name of the data connection from "DataConn" to "AdvWorks," and close the Data Connection Properties window.
 * 6) From the File menu, click New, and click the File Wizards tab.
 * 7) Select Data Form Wizard and type in "Requery" in the File Name text box.
 * 8) In the "What database connection do you want to use?" list box, select AdvWorks. Click Next.
 * 9) Select the Products table, and Click Next.
 * 10) Add all fields from the Products table by clicking the ">>" button.
 * 11) Click the Next button four more times, accepting the defaults of all the remaining wizard steps. Click Finish.

You will now have the following files:
 * RequeryForm.asp
 * RequeryList.asp
 * RequeryAction.asp

Now launch RequeryList.asp in the Web browser, and select the filter button. In the filter form, type "<1/1/98" in the productintroductiondate field, and select True on for on sale. Click Apply, and then select list view. Use the buttons to move from the first and second pages. The data will not page correctly.