FIX: Error Type 11 When Using PowerMac and Reopening a Query

The information in this article applies to:

• Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

When using the Macintosh PowerPC and opening a query built from the RQBE with certain criteria selected, you receive this error:

  Sorry, a system error occurred. Microsoft FoxPro error type 11.

CAUSE

This problem appears to be caused by criteria in the RQBE that chooses a character field in the Field Name box under Selection Criteria and uses NOT IN as the operator with six to eight constants separated by commas and typed in the Example Box. The number of characters per constant may also be a factor. If a smaller number of constants are used, the error might not happen.

RESOLUTION

To work around this problem, add another statement to the Selection Criteria of the same field type, and place smaller increments of what you included in the first Selection Criteria statement. It seems that any number over three or four items causes the error. It might take several Statements to get the number of items down to three or four per line in the Example box.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was fixed in Microsoft Visual FoxPro for Macintosh version 3.0b.

MORE INFORMATION

Steps To Reproduce Problem

1. Open the Customer database in the FPM26:TUTORIAL folder.

2. Open the RQBE by clicking the RUN option on the menu bar and selecting New Query.

3. Click the Order By check box and add Customer.state to the Ordering Criteria box.

4. Under the Selection Criteria section, choose Customer.state in the Field Name box.

5. Click the NOT box, and choose IN located in the list box beside the NOT box.

6. In the Example box, type:

   AK, AL, CA, NY, NC, MO, TX, OR

7. Save the query by holding down the Control key and pressing the W key. Give the query a name when prompted, and press RETURN. Click Yes to save changes.

8. Click FILE, OPEN on the menu bar, and change the TYPE: popup to Query. Click the file name of your query, and select the Open push button.