Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
problem is there are many fields to monitor in many tables
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
Why do you need to fix it? The Qlik engine will interpret both as TRUE...
See On Boolean Fields and Functions
HIC
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