BROWSE COLUMN WIDTHS SAVED (6.1)

When browse column widths are resized by an Admin user and the view closed, the option is offered the user of saving the new column widths permanently for that view.

LABEL FONT COLORS (6.1)

If the label font color is either White or Black, the program will use both White and Black, depending on the background color. If the background color is dark (sum of RGB components < 500), White text is displayed. If the background color is light (sum of RGB components >= 500), Black text is displayed. This allows all the standard colors to be used in the same form for label background colors. This behavior can be disabled by using any color that is not pure White or pure Black, ie. (0,0,0) for black and (255,255,255) for white.

DROPLIST QUERY PARAMETERS (6.1)

The query for droplists/listboxes/etc. can be passed a fieldname parameter. This allows the query to be customized for the current record. Example: The query selects all the employees from the EMPLOYEE table. If you really only need the employees
for a certain department and the department id field is filled in, the query can now contain a where clause that only selects employees from the desired department, thus giving a much shorter list.

First query selecting all employees:
SELECT EmplName FROM EMPLOYEES
Second query selecting only the desired employees:
SELECT EmplName FROM EMPLOYEES WHERE EmplDepartment = {@"Dept"}

Table EMPLOYEES which will fill the droplist contains fields:
EmplName the name of the employee
EmplDepartment the department code for this employee
Table XYZ which this view is based on contains the field:
Dept the department code for this employee

This {@"xxx"} syntax must include the double quotes surrounding the field name,   regardless of whether or not the field name contains spaces or special characters.

Drop List Query Parameters (6.1)

The query for droplists/listboxes/etc. can be passed a fieldname parameter.  This allows the query to be customized for the current record.

Example: The query selects all the employees from the EMPLOYEE table.  If you really only need the employees for a certain department and the department id field is filled in, the query can now contain a where clause that only selects employees from the desired department, thus giving a much shorter list.

      First query selecting all employees:

         SELECT EmplName FROM EMPLOYEES

      Second query selecting only the desired employees:

         SELECT EmplName FROM EMPLOYEES WHERE EmplDepartment = {@"Dept"}

      Table EMPLOYEES which will fill the droplist contains fields:

            EmplName          the name of the employee

            EmplDepartment    the department code for this employee

      Table XYZ which this view is based on contains the field:

            Dept              the department code for this employee

       This {@"xxx"} syntax must include the double quotes surrounding

      the field name, regardless of whether or not the field name

      contains spaces or special characters.

Drop Lists Filled Each Time (6.1)

All list controls now load the list contents from the defined query each time the list is dropped. This allows the list to show an accurate list that reflects any changes just made to the table from which the query selects records. Previously the lists were filled only once, when the view was displayed.

Drop List Performance (6.1)

Much better performance for views containing large drop lists or many such lists on the same page. The contents of the lists are not loaded when the view is displayed or new pages are displayed. A list is only loaded when the user drops it to make a selection.

Standard Label Font Colors (6.1)

If the label font color is either White or Black, the program will use both White and Black, depending on the background color.  If the background color is dark (sum of RGB components < 500), White text is displayed.  If the background color is light (sum of RGB components >= 500), Black text is displayed.  This allows all the standard colors to be used in the same form for label background colors. This behavior can be disabled by using any color that is not pure White or pure Black, ie. (0,0,0) for black and (255,255,255) for white. If the label font color is either White or Black, the program will use both White and Black, depending on the background color.  If the background color is dark (sum of RGB components < 500), White text is displayed.  If the background color is light (sum of RGB components >= 500), Black text is displayed.  This allows all the standard colors to be used in the same form for label background colors. This behavior can be disabled by using any color that is not pure White or pure Black, ie. (0,0,0) for black and (255,255,255) for white.

Custom Label Fonts and Colors (6.1)

Each label in the view can have a custom font, font color, and background color. Example: you can have a label with a large 18 point font to use as the heading for
a group of fields, and its colors can be any colors supported by your video settings.

Browse Record #'s (6.2)

To display or hide the record number buttons on the browse screen, design the view and click the View Settings button on the lower toolbar, then select the Browse tab.

Record #'s        If checked, record number buttons will be placed at the left end of each record.

This can be set for all views in the database that use the default database view settings by choosing Main Menu option File | Database Settings then selecting the Browse tab.

Browse Controls use Default Query (6.2)

When a Browse Control is added to a view, you specify the link fields that determine which related records from the Browse Control table are selected to display in the Browse Control.  The browse control view has it's own default query, which can select records and determine the sort order of the records.  This is now combined with the link fields to allow much more flexible selection of records.  Example: Display all invoices for the customer that have a balance due.