SORTORDERSPECEX (EDB) (Windows CE 5.0)
This structure contains information about a sort order in a database. The structure is used when calling the CeOpenDatabaseInSession (EDB) function and is also included in the CEDBASEINFOEX (EDB) structure.
typedef struct CESORTORDERSPECEX { WORD wVersion; WORD wNumProps; WORD wKeyFlags; WORD wReserved; CEPROPID rgPropID[CEDB_MAXSORTPROP]; DWROD rgdwFlags[CEDB_MAXSORTPROP];} CESORTORDERSPECEX;
Members
- wVersion
Version of this structure; must be set to 2. - wNumProps
The number of properties in this sort order, which must not be more than SQLCE_MAXSORTPROP (16). - wKeyFlags
One or a combination of additional constraints to the sort order. The following flags are supported for this member.Flag Description 0 (zero) Adds no additional constraints to the sort order. CEDB_SORT_UNIQUE Requires the key to be unique across all records in the database. CEDB_SORT_NO_POSITIONAL Specifies that positional access should not be allowed. CEDB_SORT_PRIMARYKEY Specifies a unique sort order. Only one can be created per database. - wReserved
Reserved; do not use. - rgPropID
An array of properties on which to sort. Sorting occurs in the order in which the properties are specified in the array. - rgdwFlags
The sort flags that correspond to the properties in rgPropID. To sort differently, specify one or a combination of the following flags:- CEDB_SORT_DESCENDING
- CEDB_SORT_CASEINSENSITIVE
- CEDB_SORT_UNKNOWNFIRST
- CEDB_SORT_IGNORENONSPACE
- CEDB_SORT_IGNORESYMBOLS
- CEDB_SORT_IGNOREKANATYPE
- CEDB_SORT_IGNOREWIDTH
- CEDB_SORT_NONNULL
Remarks
The default sort is ASCENDING, CASE_SENSITIVE.
The following list highlights the differences between this structure and the CEDB equivalent structure:
- In EDB, two new flags are available for setting features of the sort order:
- CEDB_SORT_NO_POSITIONAL
- CEDB_SORT_PRIMARYKEY
- If a sort order is constrained to be unique, EDB allows a single NULL to occur, but in CEDB no NULLs are permitted. For example, if there are two properties in a sort order, then EDB considers "A,B","A,NULL", "NULL,B" and "NULL,NULL" to each be unique.
Requirements
OS Versions: Windows CE 5.0 and later.
Header: Windbase.h.
Link Library: Coredll.lib.
See Also
CeOpenDatabaseInSession (EDB) | CEDBASEINFOEX (EDB)
Send Feedback on this topic to the authors