Result set display options

WinSQL offers multiple options to display query results. These options are:

• Grid
• Text
• Form

Displaying results in Grid

This is the default option and there are several benefits when results are displayed in this format. For example, you can: Copy one or more cells to the clipboard Save the contents to a .CSV, .TXT or MS Excel file Print the results Double click to edit the record Primary and foreign keys get displayed in a different color. Clicking the plus sign brings up the associated record. Easily "Zoom" on large data Can display images and rich contents There is no limit on how many records are displayed as incoming records are not stored in memory

Displaying results in Text

Use this option to display large text. For example, you can: Display all fields as one big text Save the contents to a fixed length file Easily copy the contents to clipboard Important: Result sets are NOT editable when displayed in this mode and the number of records displayed are restricted by available memory.

Displaying results in Form

When results are displayed in a Form window, you can: Easily modify the data Conveniently view multi-line data Press ALT+Left Arrow to move the next record Press ALT+Right Arrow to move the previous record Jump to a desired record by specify a record number There is no limit on how many records are displayed as incoming records are not stored in memory