Boolean (bit 1/0) vary depending on conncetion statement
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]);