BUG: "Alias Name Already in Use" from SQL Query Wizard

 Last reviewed: June 27, 1995
Article ID: Q114496
The information in this article applies to:
  • Microsoft FoxPro for Windows, versions 2.6
  • Microsoft FoxPro for MS-DOS, versions 2.6

SYMPTOMS

The SQL Query Wizard will produce the following error message if two tables with names such as 1CUST.DBF and _1CUST.DBF are added to a query: 

   Alias name is already in use

RESOLUTION

To avoid this problem, rename one of the tables.

STATUS

Microsoft has confirmed this to be a problem in FoxPro version 2.6 for MS-DOS and Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

  1. Create two copies of CUSTOMER.DBF: one called _1CUST.DBF and one called 1CUST.DBF.

  2. Add both files to the Catalog Manager under the Table tab.

  3. Create a new query with the SQL Query Wizard.

  4. Move _1CUST.DBF from the first column to the second.

  5. Move 1CUST.DBF from the first column to the second.

The Query Wizard will display the error message "Alias name is already in use."

Additional reference words: FoxDos FoxWin 2.60 dbf errmsg err msg
buglist2.60
KBCategory: kbtool kbprg kbbuglist kberrmsg
KBSubcategory: FxtoolWizother

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: June 27, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.