>I have the following SQL that is acting strange.
>
>select I.code, I.reference, I.title, ;
>A.name as Artist,i.artist as artistcid ;
>from inventry as I inner join artist as A on ;
>(A.cid = I.artist) ;
>order by reference
>
>Artist.cid and Inventry.artist are char 6 key values.
>
>the problem is that when I run this uncompiled it works as expected. When I create an .exe it returns many doubled records.
>
>For example:
>one line in the query shows " Ha" as the CID with Tipica Novel as the artist. The next line shows " Ha" and Trio Los Panchos as the artist. This appears that the SQL parser is not looking at case sensitivity of the Artist.cid index and assumes that " HA" (the real Tipica Novel) is the same as " Ha" ( the real Trio Los panchos). Am I missing a SET command in the runtime, is this a bug, or did I miss something obvious;
>
>Thanks,
>Jon
Also look at SET ANSI and SET EXACT.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer