WCEDBTST

The WCEDBTST sample demonstrates how to use the CCeDBDatabase, CCeDBRecord, CCeDBProp, and CCeDBEnum classes to create, destroy, sort, enumerate, access, and edit a Windows CE database in the object store.

To test the various operations you can perform on a Windows CE database, select any of the following commands from the File menu.

• The Basic Test command checks to see if a certain database exists in the object store. If the database exists, it opens it and then deletes it. Then it creates a new database, checks to verify that it was created, closes it, opens it again, and deletes it.
• The Enumeration Test command creates three databases, and assigns the application-defined identifier '99' to each of them. It then creates two enumerators. The first enumerator enumerates all the databases in the object store; the second one enumerates only those databases that have the identifier '99.' The enumerators iterate through the specified databases, and the application retrieves the name and latest modification time of each one, and prints it to the display.
• The Sort Test command creates a sample database and prints its contents to the display. Then it opens the database three times specifying a different sort property each time, and prints the results of each sort operation to the display. The first time, it specifies Age as the sort property. The second time it specifies Gender. Then it uses the sort property flags to reverse the sort order of the Last Names sort property, so the database is sorted alphabetically by last name, but in descending order, rather than ascending.
• The Modify Test command creates a sample database and prints its contents to the display. Then it searches for a record that contains a specific value for a specific property (a person's last name), and changes the value of a different property in the retrieved record (the person's age). Then it prints the contents of the database to the display again.
• The Seek Test command creates a sample database and prints its contents to the display. Then it performs several seek operations, printing the retrieved record to the display after each successful seek. It seeks the first record, the last record, and the second record, and saves a pointer to the second record so it can return to it later. Then it seeks the second from the last record, then the previous record, and then it returns to the record to which it previously saved a pointer. After that, it seeks the first record that has the value "Smith" for the Last Name property. Then it proceeds to seek the next two records in the database that also have the value "Smith" for their Last Name property. The second seek fails, because there are only two Smiths in the database. Then it seeks any previous records that have a smaller last-name value then "Evans", and finds two. Finally, it seeks the next record that has a last-name value greater than or equal to "Evans".
• The Deletion Test command creates a sample database and prints its contents to the display. Then it deletes a record and writes the contents of the database to the display again. Then it seeks a different record and deletes two properties from the record. After writing the contents of the database to the display again, it seeks another record, deletes a single property, and updates the display one more time.

These samples demonstrate the following keywords:

You can find the WCEDBTST project files in the Wce\Samples\Mfc\WCEDBTST directory.

For information on the Windows CE platforms that support this sample, see MFC for Windows CE Samples.