Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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