I ran a quick test with the MS driver using SELECT DISTINCT and it worked.
Can you post the code that you are using? Perhaps there is something else
that is happening.
Thanks.
SuePurkis
DataDirect Technologies
"Gonçalo" <Gonalo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B3FCD484-53E7-42E3-AD22-26236C9F3927@xxxxxxxxxxxxxxxx > I'm using the last version of JDBC driver, and the following query is
> returning duplicate values:
> SELECT DISTINCT COMPANY_ID C1 FROM COMPANY_WORKERS
>
> By if i make de following query, it works:
> SELECT A.C1 FROM (SELECT DISTINCT COMPANY_ID C1 FROM COMPANY_WORKERS ) A
>
> Both queries work ok in the SQL Analyzer, but in the code only the second
> one works as espected.
>
> Thanks
> Gonçalo
Re: Oneys Book, HandleQueryStop(): Why is there no race condition? ... The simplest approach is to just deny the query.... allow the query but leave the system vulnerable as the race condition cannot ... >> If there is need to stop the device, the driver should be ... >>> Conexant Systems, Inc. ... (microsoft.public.development.device.drivers)
RE: Calculating the cumulative totals for an ending result ... Your query fields do not correspond the sample data. ... FROM Odometer INNER JOIN Movement ON Odometer.Unit = Movement.Unit ..."KARL DEWEY" wrote: ... 'Business KM and Personal KM' per unit# with the driver for the month. ... (microsoft.public.access.queries)
Re: Order in bind variable for PreparedStatement in Java ... > I have a critical problem with a prepared query and bind variable in Java. ... > I am confused because it seems that the jdbc driver bind the variable ... > bind variables.... > My Jdbc informix driver is 2.21.JC5 ... (comp.lang.java.databases)
Re: Oracle parameter problem with OraOLEDB driver ..."Mick Board" wrote in message ... I am using this driver rather than the ... > I have a query which contains parameters, one of which is an integer. ... > query has its datasource value set to a datasource as it is the detail ... (borland.public.delphi.database.ado)
