SQL Workaround?

[gers0667]

I'm syncing an Access Database via Active Sync and using eVB to access it. I want to do a SELECT DISTINCT x FROM x, which is valid in Access, but I get errors running it on the PocketPC. Can anyone think of a work around for this one??

[gers0667]

I'm syncing an Access Database via Active Sync and using eVB to access it. I want to do a SELECT DISTINCT x FROM x, which is valid in Access, but I get errors running it on the PocketPC. Can anyone think of a work around for this one??

[gers0667]

I got around the problem by sorting the list and then did a comparison:

Last = ""

Do While Not oRecordset.EOF
    Current = oRecordset.Fields("Type")
    If Current <> Last Then
        Last = Current
        lstType.AddItem Current
    End If
    oRecordset.MoveNext
Loop