topic Re: Bit/Boolean Changes from positive (1) to negative(-1) over oledb connection in QlikView

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

amirkachlon — Mon, 24 Aug 2015 13:47:58 GMT

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

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

marcus_sommer — Mon, 24 Aug 2015 14:45:11 GMT

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

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

amirkachlon — Mon, 24 Aug 2015 15:24:13 GMT

problem is there are many fields to monitor in many tables

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

marcus_sommer — Mon, 24 Aug 2015 15:39:33 GMT

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+oledb+connection

- Marcus

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

hic — Tue, 25 Aug 2015 09:55:17 GMT

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

See On Boolean Fields and Functions

HIC

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

amirkachlon — Tue, 25 Aug 2015 11:20:09 GMT

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