Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Boolean (bit 1/0) vary depending on conncetion statement

Hi!

I have noticed that Qlikview handle data type boolean (bit 1/0) diffrent if I write connection statement in the script or if I establish a permanent database connection through ODBC Data Source Administrator. Has this happend for you? If i establish permanent connection it works fine but if I use this connection statment below 1 becames -1.





CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=[xxxx];Initial Catalog=[xxxx];Data Source=[xxxx];Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=[xxxx];Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is [xxxx]);



/K

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't have an experience with your specific question, but -1 is True in QV as is 1. So they are logically equal if used in boolean expressions.

-Rob