BUG: Reserved Error when Entering Certain Valid SQL Statements

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

SYMPTOMS

When using the DataForm wizard and selecting a SQL statement as a recordset type in step 2, if you enter a statement that selects more than two fields with the same name, either from a view or by multiple table selection, the DataForm wizard prompts a reserved error.

CAUSE

The problem is with the error handling in the wizard framework.

RESOLUTION

The workaround for this problem is to alias the second occurrence of the duplicate field names within the SQL statement. For example, "select authors.city, stores.city town from authors, stores" works, but the SQL statement below does not.

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. Open a project.

  2. Insert a dataconnection to pubs.

  3. From the File menu, select New, File Wizards, then Data Form Wizard.

  4. In step 1 of the Wizard, select the connection to pubs.

  5. In step 2, select "SQL statement, "next."

  6. In step 3, type the following valid SQL statement:

          select * from authors, stores
    

  7. Click Next.

A reserved error (-2147220496) appears, and the wizard shuts down.

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          : VIDataTools VIWizards kbtool kbbuglist
Version           : 1.0
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.