Microsoft KB Archive/114270

{| = FIX: CTOD and VAL Functions Are Not Saved in Query =
 * width="100%"|

ID: Q114270

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.

Steps to Reproduce Problem
1. Type the following in the Command window:

CREATE TABLE test (chardate C(8)) INSERT INTO test (chardate) VALUES ('02/20/94') MODIFY QUERY test

2. 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 (). Select the Expression Builder ().

3. In the Expression Builder dialog box, under Expression, type the following, and then choose OK.

CTOD(chardate)

4. Type the following in the text box under Example:

{02/20/94}

5. Choose See SQL. Note that the generated SQL SELECT statement is   correct. Close the See SQL window.

6. Close the RQBE window, saving changes to TEST.QPR.

7. Type "MODIFY QUERY test" (without the quotation marks) in the Command window to open TEST.QPR again.

8. Note that the CTOD function is missing from the expression under Field Name.

9. Choose See SQL. Note that the CTOD function still exists in the generated SQL SELECT statement. Close the See SQL window. 10. Change the LIKE operator to EXACTLY LIKE. 11. Choose See SQL. Note that the CTOD function is now missing from

the generated SQL SELECT statement. Additional reference words: FoxMac FoxDos FoxWin 2.50 2.50a 2.50b buglist2.50 buglist2.50a buglist2.50b structured query language buglist2.60 fixlist2.60a KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxtoolRqbe Keywords         : FxtoolRqbe kbbuglist kbfixlist Version          : 2.50 2.50a 2.50b 2.60 | 2.50 2.5 Platform         : MACINTOSH MS-DOS WINDOWS Solution Type    : kbfix
 * }