PRB: Error Type 11 Caused by Including Quotes on Date in RQBE

ID: Q129755

2.60a MACINTOSH kbtool kbprb

The information in this article applies to:

Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a

SYMPTOMS

If a date in the Example box of the Selection Criteria in RQBE is enclosed in quotation marks, the following error occurs when you click the Do Query button:

   Invalid date. Enter date in the form:
   04/26/95

After you press a key or click the mouse, the following error is displayed:

   Missing )

If you then attempt to correct the date, you may continue to get the previous error message and be able to correct the date, or you may get this error message:

   The application unknown has unexpectedly quit,
   because an error of type 1 occurred

If you are able to correct the date by removing the quotation marks, the following error occurs when you again click the Do Query button:

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

NOTE: This behavior does not occur in Visual FoxPro 3.0b for Macintosh.

WORKAROUND

If you receive the "Invalid Date" message, followed by the "Missing )" error, you need to force FoxPro to quit in order to prevent the "type 11" error. You can do this by holding down the CMD+OPTION keys and pressing the ESC key.

STATUS

Microsoft is researching this issue and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

1. Type the following in the Command window:

   USE :tutorial:invoices
   CREATE QUERY

2. In the Selection Criteria, select invoices.idate as the Field Name,

   and type "05/08/90" (including the quotation marks) in the Example.

3. Choose the Do Query button.

4. The first two error messages are displayed. Place the mouse pointer

   (cursor) in the Example box while the second message is displayed. This
   will clear the message and move the pointer.

5. If the "Missing )" error message continues to appear throughout this

   step, continue to press a key to clear the message. Correct the date by
   removing the quotation marks. The "type 1" error may occur while you
   attempt to correct the date.

6. Choose the Do Query button.

7. The "error type 11" message is displayed.

Additional reference words: FoxMac 2.60a KBCategory: kbtool kbprb KBSubcategory: FxtoolRqbe

Keywords          : FxtoolRqbe 
Version           : 2.60a
Platform          : MACINTOSH