strange OLEDB select result

[#1]

Hi,

I isolated a bug in my application :

I load data from a MS sql 2008 DB

OLEDB CONNECT TO [...]

select AFF_AFFAIRE,AFF_AFFAIRE1,AFF_AFFAIRE3 from affaire;

now , for a selection that should give me one row, qlikview gives me two :

If I try the same thing in SQL management studio :

select AFF_AFFAIRE from AFFAIRE where AFF_AFFAIRE1='ITC' and AFF_AFFAIRE3='1312D5'

I get :

AFF_AFFAIRE

AITC592541312D500

which is the correct behavior.

What am i missing ?

Jo.

[mrybalko · Accepted solution]

You can use code:

affaire: 

LOAD 

    *,

    text(AFF_AFFAIRE3) as AFF_AFFAIRE_; 

select  ....

DROP FIELD AFF_AFFAIRE3;

RENAME FIELD AFF_AFFAIRE_ to AFF_AFFAIRE3;

[#3]

I like your solution,

it's way better than my 2 requests per table.

Thank you.