Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100557

From BetaArchive Wiki

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

ID: Q100557

2.50 2.50a WINDOWS kbprg kbprb

The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5 and 2.5a


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.


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.


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.

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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.