PRB: Using RQBE, the See SQL Information Is Not UpdatedID: Q100557 2.50 2.50a WINDOWS kbprg kbprb The information in this article applies to:
SYMPTOMSWhen 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. RESOLUTIONTo 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 INFORMATIONSteps to Reproduce Problem1. 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. 7. In the Name box, change the name to JUNK1.DBF. 8. With the mouse, change the Example box of the selection criteria to read "ab" (without the quotation marks). 9. Choose the See SQL button. Note that the table name is not updated to JUNK1.DBF. Additional reference words: FoxWin 2.50 2.50a KBCategory: kbprg kbprb KBSubcategory: FxtoolRqbe Keywords : FxtoolRqbe Version : 2.50 2.50a Platform : WINDOWS |
Last Reviewed: April 30, 1996 |