topic Re: Can we write ADO.net coding inside the Macro? in QlikView

Can we write ADO.net coding inside the Macro?

Tue, 20 Nov 2012 06:43:39 GMT

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.

Re: Can we write ADO.net coding inside the Macro?

Anonymous — Tue, 20 Nov 2012 06:51:35 GMT

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?

Re: Can we write ADO.net coding inside the Macro?

Tue, 20 Nov 2012 07:04:37 GMT

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.

Re: Can we write ADO.net coding inside the Macro?

Anonymous — Tue, 20 Nov 2012 07:05:50 GMT

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.

Re: Can we write ADO.net coding inside the Macro?

Tue, 20 Nov 2012 07:12:45 GMT

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.