SORTORDERSPECEX (EDB) (Windows CE 5.0)

Send Feedback

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

Feedback FAQs

© 2006 Microsoft Corporation. All rights reserved.