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
Gonalo,
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
"Gonalo" <Gonalo@.discussions.microsoft.com> wrote in message
news:B3FCD484-53E7-42E3-AD22-26236C9F3927@.microsoft.com...
> 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
> Gonalo
sql
Showing posts with label driver. Show all posts
Showing posts with label driver. Show all posts
Sunday, March 25, 2012
DISTINCT not working
Sunday, February 19, 2012
display properties
hi, i cant seen to change my color settings or the size of
my desktop. i dont know what my driver is and i have tried
installing others out of the list given on the win98 disk
and it isnt working, can somebody please help me out
because i cant view anyting in a higher resolution and i
cant access any programs, thanks.
This is a SQL Server newsgroup and has absolutely nothing to do with Windows
98 display problems. How about trying
microsoft.public.win98.display.general?
Good luck!
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"mike" <mickmckenna2003@.aol.com> wrote in message
news:126d801c442a9$8f43fbc0$a501280a@.phx.gbl...
> hi, i cant seen to change my color settings or the size of
> my desktop. i dont know what my driver is and i have tried
> installing others out of the list given on the win98 disk
> and it isnt working, can somebody please help me out
> because i cant view anyting in a higher resolution and i
> cant access any programs, thanks.
my desktop. i dont know what my driver is and i have tried
installing others out of the list given on the win98 disk
and it isnt working, can somebody please help me out
because i cant view anyting in a higher resolution and i
cant access any programs, thanks.
This is a SQL Server newsgroup and has absolutely nothing to do with Windows
98 display problems. How about trying
microsoft.public.win98.display.general?
Good luck!
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"mike" <mickmckenna2003@.aol.com> wrote in message
news:126d801c442a9$8f43fbc0$a501280a@.phx.gbl...
> hi, i cant seen to change my color settings or the size of
> my desktop. i dont know what my driver is and i have tried
> installing others out of the list given on the win98 disk
> and it isnt working, can somebody please help me out
> because i cant view anyting in a higher resolution and i
> cant access any programs, thanks.
Subscribe to:
Posts (Atom)