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

ID: Q125519

2.60a MACINTOSH

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.

You then have to click the Restart button or press the reset button to regain control of the computer. This happens only with the PowerPC using version 7.0 or later of the Macintosh System software.

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.

Upon opening the query, FoxPro will crash, giving the above mentioned error message. This error will not occur when fewer than five constants are in the Example field. If each constant contains more letters, the system may crash with even fewer constants in the Example box.

Additional reference words: FoxMac 2.60a buglist2.60a errmsg err msg KBCategory: KBSubcategory: FxtoolRqbe

Keywords          : kb3rdparty kberrmsg FxtoolRqbe 
Version           : 2.60a
Platform          : MACINTOSH
Solution Type     : kbfix