2.50 2.50a 2.50b 2.60 | 2.50 2.50a 2.50b 2.60 | 2.50b
WINDOWS | MS-DOS | MACINTOSH
kbprg kbfixlist kbbuglist
The information in this article applies to:
- Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
- Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b, 2.6
- Microsoft FoxPro for Macintosh, version 2.5b
SYMPTOMS
A query produced by the Relational Query By Example (RQBE) window that
contained the VAL() or CTOD() functions when it was last saved is missing
those functions the next time it is opened.
STATUS
Microsoft has confirmed this to be a problem in FoxPro versions 2.5, 2.5a,
and 2.5b for Windows, FoxPro versions 2.5, 2.5a, and 2.5b for MS-DOS, and
FoxPro version 2.5b for Macintosh. This problem was corrected in FoxPro
version 2.6a for Windows, FoxPro version 2.6a for MS-DOS, and FoxPro
version 2.6a for Macintosh.
MORE INFORMATION
Steps to Reproduce Problem
- Type the following in the Command window:
CREATE TABLE test (chardate C(8))
INSERT INTO test (chardate) VALUES ('02/20/94')
MODIFY QUERY test
- Click the box under Field Name. A list box appears. The choices in the
list box are the field TEST.TESTDATE and the Expression Builder
(<expression...>). Select the Expression Builder (<expression...>).
- In the Expression Builder dialog box, under Expression, type the
following, and then choose OK.
CTOD(chardate)
- Type the following in the text box under Example:
{02/20/94}
- Choose See SQL. Note that the generated SQL SELECT statement is
correct. Close the See SQL window.
- Close the RQBE window, saving changes to TEST.QPR.
- Type "MODIFY QUERY test" (without the quotation marks) in the
Command window to open TEST.QPR again.
- Note that the CTOD() function is missing from the expression under
Field Name.
- Choose See SQL. Note that the CTOD() function still exists in the
generated SQL SELECT statement. Close the See SQL window.
- Change the LIKE operator to EXACTLY LIKE.
- Choose See SQL. Note that the CTOD() function is now missing from
the generated SQL SELECT statement.
|