Microsoft KB Archive/129755

{| = PRB: Error Type 11 Caused by Including Quotes on Date in RQBE =
 * width="100%"|

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.

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