FIX: Nested SQL Select Fails on Macintosh

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

Last Reviewed: October 20, 1997