BUG: GPF or Crash When Entering Empty Date Field in RQBE

 Last reviewed: April 30, 1996
Article ID: Q108335
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.

MORE INFORMATION

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.

REFERENCES

"Getting Started," version 2.5, Chapter 5 "Language Reference," version 2.5, page L1-12

Additional reference words: FoxMac FoxWin buglist2.50 buglist2.50a
buglist2.50b
2.50 2.50a 2.50b crash GPF UAE quit end errmsg err msg 2.60 buglist2.60
KBCategory: kbtool kbbuglist
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: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.