Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amirkachlon
New Contributor III

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

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

5 Replies

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

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
New Contributor III

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

problem is there are many fields to monitor in many tables

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

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

Employee
Employee

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

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

See On Boolean Fields and Functions

HIC

amirkachlon
New Contributor III

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

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

Community Browser