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

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

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

Last Reviewed: May 2, 1996