How to Use RQBE to Output a Query to an ASCII Text File

 Last reviewed: April 30, 1996
Article ID: Q114313
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.0, 2.5, 2.5a, 2.5b, 2.6

To direct the ouput of a FoxPro query within the Relational Query By Example (RQBE) tool to an ASCII text file, do the following:

  1. Set up your query within the RQBE window.

  2. From the Output box, select Report/Label.

  3. Select the Options check box.

  4. In the RQBE Display Options dialog box, select the Screen Display radio button.

  5. Under Output Destinations, select the To File check box.

  6. Type a name for your file (for example, ASCII.TXT).

  7. Choose OK twice, then choose the Do Query button to create your file.

To see the code generated by these settings, choose the See SQL button. You can copy and paste this code into a program. It will look something like: 

   SELECT <fields> from <FoxPro table> to FILE <ASCII filename>

REFERENCES

"Interface Guide," version 2.0 (MS-DOS), pages G14-1-17 "User's Guide," version 2.5 (MS-DOS), pages U14-1-21 "User's Guide," version 2.5 (Windows), pages U13-1-22

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a 2.50b 2.60
KBCategory: kbprg
KBSubcategory: FxtoolRqbe

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.