Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/108335

From BetaArchive Wiki

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

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


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.


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


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.


"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

Keywords          : FxtoolRqbe kbbuglist
Version           : 2.50 2.50a 2.50b 2.60 | 2.50b
Platform          : MACINTOSH WINDOWS

Last Reviewed: May 2, 1996
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.