I want to read the data from the data base through Macro.
So, I want to run the ADO.net codes.
Is this run or not?
You can run any type of VBScript or Jscript you want. The question is more what use you would have of loading data from a DB from inside the QlikView macro module?
I want to do real time data update(Data base update reflect into QVW) that s y?
I have one more qus,
In macro below syntax is not work.
Dim A as String
Dim Connection as New SqlConnection(ConnectionString)
My suggestion would be to wait for v11.2 and try out the Direct Discovery functionality to see if it will satisfy your needs of real time information.
Just, I put a try to do this for my knowledge.
Please tel me How to use the Dim Keyword in macro?
It gives a error like "Expected end of statement" While testing.
Retrieving data ...