This page of the wizard of adding/changing an EDB table as a VIEW permits viewing and changing sorting condition and disabling or enabling display of identical (duplicated) records in the view.
Fields of query | The list Query fields contains names of all columns (fields) of EDB tables on the base of which the given view is built. Fields participating in the sorting conditions are marked by the arrow sign, the arrow directed upwards means ascending sorting order, downward – descending order. The order of fields in the list determines field priority in sorting conditions. The higher the position of the field name in the list, the higher its priority is. Sorting is performed at first by the field with the highest priority, and then the records having equal values of higher priority field are sorted by fields with lower priorities. The group of radio buttons Order serves for indicating the order of sorting for the field selected in the list. The radio button Undefined denotes that the field does not take part in the sorting condition. |
Duplication of records | The checkbox Enabled allows enabling or disabling display of identical (duplicated) records in table browser window. |
Adding EDB table as a view in data source