config1.pngSetting SQL Options

The Edit SQL configuration page is used to enable SQL, define the path to the SQL.INI file, edit and print the SQL.INI file, and enter Data Source properties.

To enable the Visual PRO/5 SQL engine, click the Enable SQL check box. SQL must be enabled before you can access the other controls on this configuration page.

Defining the SQL.INI file path

  • To enter the location of the SQL.INI file, click the Path field and specify the location. If the path is not specified, PRO/5 assumes that the sql.ini file is located in the current directory.

  • To open the SQL.INI file for viewing, click Open. A standard Windows file open dialog will be presented for selecting the SQL.INI file to open.

  • To print the current SQL.INI file, click Print. A standard Windows print dialog box will be presented.

  • To preview the current SQL.INI file, click Print Preview. A standard Windows print preview dialog box will be presented.

  • To save edits to the current SQL.INI file, click Save.

Defining the Data Source Name and Configuration File

To add BASIS data sources to the SQL.INI file, use the Data Source group. BASIS data sources are databases that have been defined in the BASIS Data Dictionary. Each BASIS data source must have an associated config.TPM file. The Data Source group will be disabled until an SQL.INI value has been filled in.

The Data Source group box contains a two-column dynamic grid control for entering data source properties.

  • To Add a data source, click Add.

  • To Remove a data source, click the row that contains the data source name, then click Remove.

  • To edit an existing data source, click on the row that contains the data source name.

  • To set the data source name, click in the column Data Source Name column and enter the name.

  • To set the location of the data source configuration file, do the following:

  1. Click in the Configuration file column.

  2. Enter the location of the configuration file that contains parameters for this data source.

  3. The configuration file for each data source indicates where the physical dictionary and the logical data for that data source exist. Lines that begin with a "#" are comments. Ensure that the DICTIONARY value points to the physical location of the BASIS Data Dictionary. Often, to resolve the location of the file paths defined in the dictionary, it is necessary to establish a global path to that data. If this is the case, then you should also define all the globals in your dictionary configuration file that are required to resolve the physical path to your data. This is typically the DATA value.

  • To search system for a configuration file, click Browse to display a standard open dialog box.

  • If modifications have been made to the Data Source group box and the user changes focus from the configuration page without having pressed the Save button, a confirmation message will be presented to save changes.