PRB: Using RQBE, the See SQL Information Is Not Updated

• Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS

When you are creating a query using the Relational Query By Example (RQBE) tool and sending the output to a table/.DBF, the name of the table in the SQL statement is not properly updated if you change the text in the Name box.

RESOLUTION

To work around this problem, use the mouse or the TAB key to place the insertion point (cursor) in the Name box, and then choose the See SQL button.

NOTE: Visual FoxPro for Windows uses its Query Designer instead of RQBE.

MORE INFORMATION

Steps to Reproduce Problem

1. Issue the following commands:

         USE tutorial\customer.dbf
         MODIFY QUERY test
   

2. In the Output box, select Table/DBF.

3. In the Save As dialog box, name the output table JUNK.DBF.

4. In the selection criteria, select CNO for Field Name, select Like, and type "a" (without the quotation marks) in the Example box.

5. Choose the See SQL button. Note that the information is correct. Close the TEST.QPR window.

6. In the Name box, change the name to JUNK1.DBF.

7. With the mouse, change the Example box of the selection criteria to read "ab" (without the quotation marks).

8. Choose the See SQL button. Note that the table name is not updated to JUNK1.DBF.