Configuring Data Lookup Display Options
Perform the following steps to enable or disable and to configure the Data Lookup feature:
1 Start WinSQL Professional and connect to the desired database.
2 From the Edit menu, click Options.
3 Click the Intelli Tips tab. The following window displays:
4 Use the information in the following table to specify the desired parameters:
Field |
Definition |
Enable auto intelli tips |
If checked, Intelli Tips will be displayed automatically as you type your SQL queries. |
Display delay time in milliseconds |
This is the amount of time WinSQL waits after a key is pressed before displaying the Intelli Tips window. This value is in milliseconds |
Assign aliases in FROM clause |
If checked, WinSQL will assign aliases for tables in the FROM clause. For example, if this NOT checked, the query will look like: Select Customer.Name When this is checked, the query will look like: Select c.Name |
Force quoted identifiers |
If checked, WinSQL will always enclose object names in quotes. The generated query will look like: Select * When this is NOT checked, WinSQL will only put quotes on objects that have an embedded space in their name. |
Enable/Disable Data Lookup |
Select one of the following options: ·Disable data lookup: Select this option if you wish to disable Data Lookup. Doing so will prevent the Data tab from appearing in the Intelli Tip window. ·Enable for every column: Select this option to enable data lookup for every column whose data type is one of the following: 1) numeric, 2) Date/time, or 3) character (where the length is less than the specific character length). ·Enable for columns that I choose: If this option is selected, you must specifically assign a SQL query to every column for which you wish to enable data lookup. To assign a SQL query, double-click that column in the Catalog Details window (see Enable for every column, above). |
Number of records to display |
The number of records to display in the Intelli Tips window. If the query returns more than the specified number of records, they will be ignored. |
Max length for character fields |
Data lookup is enabled for fields where the column length is less than this value. For example, if there is a remarks field in a table and its size is 255, Data Lookup is not enabled for this field. This value only applies to character types. |
Max record count for a table |
For large databases, WinSQL Professional may take a long time to fetch records from a table. Therefore, if you specify a value other than -1, WinSQL Professional will only run data lookup queries for table having fewer numbers of rows than what you specify here. |