PRB: Records Displayed with Dataform Wizard Are Incorrect

Last reviewed: July 31, 1998
Article ID: Q190582

The information in this article applies to:
  • 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.

MORE INFORMATION

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 < and > buttons to move from the first and second pages. The data will not page correctly.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: 

   http://support.microsoft.com/support/vinterdev/


Keywords          : kbDSIASPGrp kbASP
Version           : WINDOWS:1.0
Platform          : WINDOWS
Issue type        : kbprb

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 31, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.