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

 Last reviewed: May 16, 1996
Article ID: Q129755
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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 16, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.