Option

Description

# of records for browsing

This is a numeric value corresponding to the number of records to display in the Browse Data feature available in the Catalog Details window. The default value is 100.

Caution:

If you set this value to a large number, WinSQL Professional will fetch a large result set whenever Browse Data is invoked. This can potentially slow down not only your machine but can also have negative affects on your network. Synametrics suggests that you instead apply filters on the records to limit the size of the returned results.

# of records to return from a query

This parameter limits the number of records that are returned from a SELECT statement. The default value is -1, which indicates no limit.

Parameter string

This token string is used to specify a parameter in the query window. The default value for this field is:

Example: The following query contains FirstName as parameter

Select * from customer where fName = ::FirstName

When this query is run, WinSQL Professional prompts for a value in the FirstName parameter field.

Maximum errors allowed in export

This option only applies to WinSQL Professional and specifies the number of errors allowed before an export routine is terminated.

Screen refresh rate

This value indicates the number of records to fetch before the screen is refreshed. This option is only applicable when results are displayed in Text control.

Write SQL string with result set

If checked, the SQL statement is printed right before the result set. This is useful if you are displaying the result in the Text control.

Enable SQL 92 syntax in query wizard

If checked, the SQL Query Wizard will use SQL 92 syntax for JOIN.

Example: The following query is written in traditional SQL

Select *

From Customers, Orders

CWhere Customers.id = Orders.id

The same query can be written in SQL 92 syntax as follows:

Select *

From Customers INNER JOIN Orders ON Customers.id = Orders.id

AutoSave sessions

If checked, WinSQL Professional will retain the window states of every connection between restarts. This retention includes queries as well as data.

Reestablish connection if broken

An attempt is made to connect to the database if the connection is severed.

Use multithreaded architecture

If selected, queries are run in a second thread. It is strongly recommended that you leave this option checked (default).

Resultset Fonts

Courier New (8)

Click the ellipses icon to change the font of the text displayed in the Result Set window.

Note: To change the font of the text displayed in the Query window, point to the Edit menu, click Options, click the Editor Options tab, and then select the desired font.

Right align numeric values

If checked, all numeric values in the result set will be right aligned. This option is only applicable when results are displayed in Text control.

Show warning messages

If checked, warning messages are displayed. This option is most helpful if the database is either Sybase or MS-SQL Server, but it can also be used by other databases. Synametrics recommends that you select this option.

Parse comments locally

If checked, WinSQL Professional will parse the query script and strip all the comments before submitting it to the back-end database.

Select a complete row in grid

If checked, individual cells within a result grid cannot be selected.  All columns for a row are selected.

Query terminator string

This string breaks the script in multiple parts, and each part is sent separately to the database. The default value for this parameter is GO, and it works in conjunction with the Terminator must be on a new line and Terminator string is case sensitive configuration options.

Terminators must be on a new line

If checked, a terminator string is only treated as a terminator if it appears on a new line.

Terminator string is case sensitive

If checked, the terminator string is case sensitive.

Terminator must be the last character on line

If checked, a terminator is recognized only if it is the last character.This is useful if you use a semi-colon for query terminator.

Include create Index statements in DDL

If selected, WinSQL includes CREATE INDEX statements when reverse engineering a CREATE TABLE statements for a table.

Reconnect on query cancel

Selecting this option forces WinSQL to close the connection when Cancel is clicked while a query is running.