Bit/Boolean Changes from positive (1) to negative(-1) over oledb connection

[amirkachlon]

Hi all,

just changed the connection to sql server dwh from odbc to oledb

since the change some bit/bollean fields changed to negative

anyone knows how to fix it?

regards,

Amir

[marcus_sommer]

I'm not sure if you could solve it with changes on the oledb-driver or on database-setting and if it's worth to spend time for it. Within qv you could use a preceeding load and changed there this value with fabs() or multiplying with -1 or some similar approach.

- Marcus

[amirkachlon]

problem is there are many fields to monitor in many tables

[marcus_sommer]

Probably there are routines possible to automate that but I think to look for possible oledb-settings might be the better way. I hope this helped: https://www.google.de/search?q=Bit%2FBoolean+Changes+from+positive+%281%29+to+negative%28-1%29+over+...

- Marcus

[hic]

Why do you need to fix it? The Qlik engine will interpret both as TRUE...

See On Boolean Fields and Functions

HIC

[amirkachlon]

Hi Henric,

In my case I have if conditions on values ('1') and not states ( True(), False() ) .

Definitely from now on I will use it but for now I dont want to change the script because it will take some time

Thanks

Amir