Has anyone had problems using the ADO provider for Oracle with a statement containing DISTINCT? My statement is "Select DISTINCT sztid from store_batch order by sztid desc" - store_batch contains 17 records, all with the same terminal id (sztid). If I use the statement above with SPT, it returns the correct 1 record, if I do the same with ADO, I get 17 records back. Is this a known problem, or am I doing something wrong?
Thanks
Rod Poujade