Microsoft KB Archive/128734

{| = FIX: Nested SQL Select Fails on Macintosh =
 * width="100%"|

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.

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
 * }