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

[#1]

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

[rwunderlich]

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