Microsoft KB Archive/108335: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 16: | Line 16: | ||
== SYMPTOMS == | == SYMPTOMS == | ||
In FoxPro for Windows, entering | 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. | On the Macintosh, FoxPro will eventually unexpectedly quit rather than cause a GP fault. | ||
Line 24: | Line 24: | ||
== RESOLUTION == | == RESOLUTION == | ||
An alternative way to query for records that have an empty date field is to type | 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 == | == STATUS == | ||
Line 42: | Line 42: | ||
<pre> Name popup. The comparison popup control should be set to Like. In the | <pre> Name popup. The comparison popup control should be set to Like. In the | ||
Example field, type | Example field, type " / / " (including the quotation marks). (There are | ||
six spaces total inside the quotation marks, two before each slash and | six spaces total inside the quotation marks, two before each slash and | ||
two after the last slash.) Without pressing any other keys or clicking | two after the last slash.) Without pressing any other keys or clicking | ||
anywhere else first, choose the Do Query button. | anywhere else first, choose the Do Query button. | ||
</pre> | </pre> | ||
At this point, an error message is displayed that says | 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 == | == 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 | 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 |
Latest revision as of 10:33, 20 July 2020
BUG: GPF or Crash When Entering Empty Date Field in RQBEID: Q108335 2.50 2.50a 2.50b 2.60 | 2.50b WINDOWS | MACINTOSH kbtool kbbuglist The information in this article applies to:
SYMPTOMSIn 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. RESOLUTIONAn alternative way to query for records that have an empty date field is to type "{ / / }" (without the quotation marks) in the Example field. STATUSMicrosoft 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 INFORMATIONSteps to Reproduce Problem1. 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 |