EDB Seek -- how edb to complex search

• From : "Rocky Lee" <rlee95129@xxxxxxxxx >
• Date : Fri, 1 Jun 2007 15:20:53 -0700

---

How do we search for group=3 and name contains string "as" using
CeSeekDatabaseEx()?
Thanks,
Rocky

"Leonard Mosescu [MS]" <lemo@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OfLY$VNkHHA.4872@xxxxxxxxxxxxxxxxxxxxxxx
I believe you'd have to :

1) Create a sort order on (group, name) - using
CeCreateDatabaseWithProps() or CeSetDatabaseInfo() as far as I remember
2) Use CeSeekDatabaseEx() with CEDB_SEEK_PREFIX |
CEDB_SEEK_VALUEFIRSTEQUAL for the group, name prefix

--
Thank you,
Leonard Mosescu, Microsoft Windows CE Compiler Team

This posting is provided "AS IS" with no warranties, and confers no
rights.

"tather" <tather@xxxxxxxxx> wrote in message
news:1178531990.436364.255380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,
I am a jackaroo, less than a month in windows ce R&D. I have a
question about edb.
I have read msdn carefully, but I do not know how to search
records according to more than one conditions.
for example:
db Property: Name - CEVT_LPWSTR
group - CEVT_UI2

table like this:
name group
----------------------------------------
aaron 1
rush 2
bush 3
nash 3
cash 3
ruby 4
cim 3

Now I want to search these records:
1) group equal 3
2) name first char is 'c'

what shall I do?

thanks a lot!

mplex search