Microsoft KB Archive/108335

{| = BUG: GPF or Crash When Entering Empty Date Field in RQBE =
 * width="100%"|

ID: Q108335

2.50 2.50a 2.50b 2.60 | 2.50b

WINDOWS              | MACINTOSH kbtool kbbuglist The information in this article applies to:


 * Microsoft FoxPro for Windows versions 2.5, 2.5a, 2.5b, 2.6
 * Microsoft FoxPro for Macintosh, version 2.5b

SYMPTOMS
In FoxPro for Windows, entering " / / " (including the quotation marks) in the Example field for a date field in the Relational Query By Example (RQBE) window will cause a general protection (GP) fault if you click the entry after you try to run the query.

On the Macintosh, FoxPro will eventually unexpectedly quit rather than cause a GP fault.

NOTE: This problem does not occur in FoxPro for MS-DOS, or in Visual FoxPro for Windows' Query Designer.

RESOLUTION
An alternative way to query for records that have an empty date field is to type "{ / / }" (without the quotation marks) in the Example field.

STATUS
Microsoft has confirmed this to be a problem in the products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Steps to Reproduce Problem
1. Use the INVOICES database in the TUTORIAL subdirectory (or any database

that has a field that is defined as a date). 2. From the Run menu, choose New Query. This will open the RQBE window. 3. In the Selection Criteria section, select Invoices.idate in the Field

Name popup. The comparison popup control should be set to Like. In the Example field, type " / / " (including the quotation marks). (There are  six spaces total inside the quotation marks, two before each slash and   two after the last slash.) Without pressing any other keys or clicking anywhere else first, choose the Do Query button. At this point, an error message is displayed that says "Invalid date. Enter date in the form: 11/24/93." This message uses the system date for the example. Then a "Missing operand" error message is displayed. This second message will be displayed repeatedly if you press the arrow keys. If you click the text in the Example field, the GP fault will occur.