This is a feature of JBuilder Professional and Enterprise.
To display this dialog, select the sort
property in the Inspector when a DataSet
component (such as a QueryDataSet
) is highlighted in the structure pane. The property values contained in this dialog are stored in the SortDescriptor
object.
The Sort property editor is used to specify properties that affect the order in which data is accessed and displayed. If no specific sort properties are set, data will be displayed in the order it was added to the table.
For more information on sorting data in a data set, see the Database Application Developer's Guide topic "Sorting data".
DataSet
columns that are available to use for sorting the data. Select a column from this list then click the Add To Sort button to sort a data set by that column.
DataSet
. To add a column to this list, select the column in the Available Columns list, then select Add To Sort. To remove a column from this list, select the column in the Column Names field, then select Remove From Sort.
StorageDataSet
- only rows with unique values for the columns defined as sortKeys
in the SortDescriptor
can be added or updated in a DataSet
.
Unique is a constraint on the data set, not just on the index. If you
define a unique index on a column, you are asserting that no two rows
in the data set have the same value in that column. If there are two
or more rows in the data set that have the same value in the unique
column when the index is first created
, any duplicate rows are moved to a "duplicates" data set.
See the Database Application Developer's Guide topic "Understanding sorting and indexing" for more information on the Unique option.