Saving and Closing Result Sets

From RapidSQL
Jump to: navigation, search

Go Up to Using the Results Editor

You can save your result sets using the standard Save and Save As functions. You can save multiple copies of the same result set and modify each copy to specific formatting requirements.

Saving Results

  1. On the File menu, select Save. The Save Results dialog opens.
  2. In the File name box, type the name of the result set.
  3. From the Save as type dropdown, select a file type of Excel 2000 or later .xls, tab-delimited, comma-delimited, pipe-delimited, user-specified delimited .txt, HTML, or XML.
  4. From the Encoding dropdown, select an encoding scheme of ANSI, UNICODE, UTF-16LE (No BOM), UTF-16 Big Endian, UTF-16BE (No BOM), UTF-8, UTF-8 (No BOM), UTF-32 Little Endian, UTF-32LE (No BOM), UTF-32 Big Endian, or UTF-32BE (No BOM).
  5. To include column titles, select Include column titles when saving.
  6. If you chose User Specified Delimiter, in User Specified Delimiter type the delimiter.
  7. Click Save.

Closing a Result Set

To close a result set, do the following:

  1. On the Main menu, click Close.
    The Result Set closes.
  2. If you have not saved your result set, you are prompted to save the file. Click Yes to save and No to close without saving.

Topics