FIX: CTOD() and VAL() Functions Are Not Saved in Query

ID: Q114270

2.50 2.50a 2.50b 2.60 | 2.50 2.50a 2.50b 2.60 | 2.50b

WINDOWS               | MS-DOS                | MACINTOSH

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

 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
    (<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.

11. Choose See SQL. Note that the CTOD() function is now missing from

    the generated SQL SELECT statement.

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