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

Tue, 16 Mar 2010 15:51:46 GMT

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]);

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

rwunderlich — Wed, 17 Mar 2010 07:12:40 GMT

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

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

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

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