Distinct Query with ADOCE
Quote:
> Hello Everyone,
> I am developing an applicaton in eVB for Pocket PC 2002.
> I have to query a table which contains around 7000 entries. I need to use
> a "Distinct" clause to query out this table. But this does not seem to be
> supported in ADOCE. Can somebody please help?
You don't have any way to do this kind of aggregate functions using CEDB.
ADOCE aren't the reason for this being unsupported. IIRC, then you can use
SSCE (SQL Server 2000 for CE) to do it.
Apart from that, the only way you have to do it is by getting a recordset,
ordered by the field (or fields) that you need to have as distinct fields,
and then loop trough this recordset and just show/use the records that fits
your criteria.
/Keld Laursen
