Hello

I'm using ADO connection.

I have this kind on code:

...
Dim rsRecordset As ADODB.Recordset
Let rsRecordset.CursorLocation = adUseClient
Call rsRecordset.Open("SELECT DISTINCT A, B FROM ...", conDB, adOpenKeyset,
adLockOptimistic, adCmdText)

The DISTINCT does not work; it has no effect: if I do select-directly to the
database (for example with Oracle Sql*Plus), I get 1 row, but rsRecordset retunrs
2 rows.

"GROUP BY " - seems to work...

We use Oracle-database.

How can I get DISTINCT-work? (This is a quite big problem in our project at the
moment.)

- I'm using NT 4.0

Thank you.