parameter_name

Navigation:  Working with databases > Working with SQL databases > Tables >

parameter_name

Previous pageReturn to chapter overviewNext page

When you store fit results to the database (see below) a corresponding table is automatically generated. Since names of  fit parameters or final numbers may violate rules for names of database columns SCOUT uses safe names like fp1 for the first fit parameter or fn3 for the third final number. This makes reading the results table difficult. The table parameter_name provides a translation of the database names to the original names used in SCOUT.

In order to retrieve the original names you have to filter out all rows which belong to the configuration of interest.You can do this by searching for the corresponding index of the configuration (column configuration_idx).

 

Columns:

clip0044

 

With version 4.67 we have introduced 2 more columns in this table (display_format,display_width) which can be used to generate a user-friendly look of results tables. When SCOUT connects to a SQL database it adds these columns automatically. The new table structure is this:

 

Columns:

clip0055

 

The column 'display_width' specifies the width of the column in pixels. If the value is 0 the column is invisible - in order to see the column you have to set a finite value. You can set a value for display_width for any column of the table.

With 'display_format' you can specify a format to show a floating point number. Make sure that you set a format for floats only - violating this may cause an access violation error. Examples of display_format values are given in the table below:

 

Floating point number

Content of display_format

Column output

3.1415287362

#0.000

3.142

3456.23245

#

3456

0.92651

#.00

.93