FIX: CTOD() and VAL() Functions Are Not Saved in QueryID: 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:
SYMPTOMSA 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. STATUSMicrosoft 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 INFORMATIONSteps to Reproduce Problem1. 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 (<expression...>). Select the Expression Builder (<expression...>). 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 |
Last Reviewed: October 22, 1997 |