BUG: New Window can Corrupt Data from Data Form Wizard Pages

Last reviewed: December 9, 1997
Article ID: Q165884
The information in this article applies to:
  • Microsoft Visual InterDev, version 1.0

SYMPTOMS

Data appears to be deleted, overwritten, or out of sync when the Data Form Wizard is used to create form-like pages using Active Server Pages (ASP). This occurs when Internet Explorer (IE) has two different browser windows. You can create an additional browser window by clicking New Window on the File menu.

CAUSE

For pages created using the Data Form Wizard, one recordset variable is used in each session of Internet Explorer, not each Window (see the MORE INFORMATION section).

RESOLUTION

The easiest solution is to not create another Window using the New Window command, but rather another instance of Internet Explorer by double- clicking its icon to launch another copy.

A new Window could be rendered inoperable programmatically by implementing a mechanism of semaphores, which allows only one window to be modifying the recordset during a session.

Another option is to redesign the output code in such a way that it uses multiple recordset variables for each session, which is an expensive solution in terms of performance (memory and computational hit on the server).

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Users connect to the Web site, go to the page created with the Data Form Wizard, and select list view. (This view shows a brief summary of approximately 10 records at a time.)

  2. The user decides to open up a new browser window so they can get two things done at once. In Internet Explorer, they go to the File menu, and click New Window.

  3. In the original window, they see a record they want to edit--let's say BOB--and they click on the BOB record to edit it in detail form.

  4. In the new window, they decide they want to edit the record JANE, and they click on the JANE record to edit it in detail form.

  5. In the original window, they change the name from BOB to ROBERT and click Update to update the data in the database.

If the users go back to the list view (see step 1), they see that BOB's record name didn't change, but JANE's record name changed to ROBERT, corrupting the data in the database.

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          : VIWizards kbtool kbbuglist
Version           : 1.00
Platform          : WINDOWS
Issue type        : kbbug


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


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: December 9, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.