Microsoft KB Archive/100557: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 35: Line 35:
4. In the selection criteria, select CNO for Field Name, select Like,
4. In the selection criteria, select CNO for Field Name, select Like,


<pre>  and type &quot;a&quot; (without the quotation marks) in the Example box.
<pre>  and type "a" (without the quotation marks) in the Example box.
</pre>
</pre>
5. Choose the See SQL button. Note that the information is correct.
5. Choose the See SQL button. Note that the information is correct.
Line 43: Line 43:
8. With the mouse, change the Example box of the selection criteria to
8. With the mouse, change the Example box of the selection criteria to


<pre>  read &quot;ab&quot; (without the quotation marks).
<pre>  read "ab" (without the quotation marks).
</pre>
</pre>
9. Choose the See SQL button. Note that the table name is not updated
9. Choose the See SQL button. Note that the table name is not updated

Latest revision as of 12:28, 19 July 2020

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

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.

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.