Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can we write ADO.net coding inside the Macro?

Hi All,

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?

Regards,

Kabilan K.

4 Replies
Anonymous
Not applicable
Author

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?

Not applicable
Author

Hi Johannes,

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)

Regards,

Kabilan K.

Anonymous
Not applicable
Author

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.

Not applicable
Author

Hi,

Yeah, but

Just, I put a try to do this for my knowledge.

Please tel me How to use the Dim Keyword in macro?

Dim A as String

Dim Connection as New SqlConnection(ConnectionString)

It gives a error like "Expected end of statement" While testing.

Regards,

Kabilan K.