Displaying Query Results

WinSQL Professional allows you to display query results in the following formats:

·Grid

·Text

·Form

It is recommended that you display results in Grid unless you are running a query that returns large amount of text containing new line characters. Managing result sets that are displayed in Grid is much easier than in Text. For example, you can save the contents of the results Grid to a CVS, tab-delimited, or spreadsheet file.

Note: The result is limited to 16MB characters per cell when the data displays in a Grid control, 4096 characters when displayed in the Text control and 32 KB when displayed in the Form control. Since it is not practical to display the entire 16 MB of data in one grid cell, WinSQL will display a magnifying glass icon if the cell data is greater than 1024 characters. You may lick the magnifying glass to zoom and view the entire data. In case of text field, data will get truncated if the length is greater than 4096 characters. This will not happen if you try to export the field to another database.

To select the method used to display query results, click the down arrow in the Execute Queries drop-down list, depicted as follows:

The resulting data display can be modified to include or exclude certain columns by clicking the X in the column header:

This functionality is also available for the Browse Data Grid option available in the Catalog Details tab.

Note: Right-click and select Display all columns to display formerly hidden columns.

Modifying results displayed in Grid

Double-click the desired row to modify the results displayed in a grid. The Update Wizard is invoked, allowing you to modify existing values.

Notes:

·You can only modify results sets that are generated from one table.

·Queries containing a JOIN statement are not editable.

·Editable and non-editable result sets display a different icon on their tabs. See image below.

Double a row to modify data. This brings up the Update Wizard.

The Update Wizard generates SQL queries as you modify data in the grid cell

Modifying results displayed in Text

Result sets in text are not editable.

Modifying results displayed in Form

To modify data, simply start typing the new value. After specifying the new values you can either press [Enter] or click Save to save the modified data to the database.

Several keyboard shortcuts can be used when the data displays in Form view. These shortcuts are described in the following table: