FIX: Nested SQL Select Fails on Macintosh

Last reviewed: October 20, 1997
Article ID: Q128734

2.50c MACINTOSH kbprg kbfixlist kbbuglist

The information in this article applies to:

Microsoft FoxPro for Macintosh, version 2.5c

SYMPTOMS

In some cases, using a nested SQL Select statement results in this error message:

   The application "Unknown" has unexpectedly quit,
   because an error of Type 1 occurred."

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in version 2.60a of FoxPro for the Macintosh.

MORE INFORMATION

Steps to Reproduce Problem

CREATE TABLE cust8ref (ocust C(8), rowid C(5), dacinit C(3)) CREATE TABLE custids (cust8 C(8), cust_id(10), dac_init C(3), cust10 C(10)) CREATE TABLE loccust (cust_id c(10)) SELECT DISTINCT ci.cust_id ;

   FROM cust8ref cx , custids ci ;
   WHERE cx.ocust = ci.cust8 ;
     AND (cust_id) NOT IN (SELECT (cust_id) from loccust)

Additional reference words: FoxMac 2.50c buglist2.50c sfixlist2.60a TYPE1
KBCategory: kbprg kbfixlist kbbuglist
KBSubcategory: FxprgSql
Solution Type : kbfix

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