Step required to call the proc/func from any object which written in QV Editor

[#1]

Hi Forums,

I had written the following code in Qlikview Editor which as follows:-

//Start Here

OLEDB

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sales_user;Initial Catalog=dummdb;Data Source=dummv01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=xxxxxxxxx;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is ramramramram);

TAB1:
Sql Select * from dum_date;
Sub Proc_1

     SQL insert into dum_date (fld1) values('C');
End sub;

//CALL Proc_1;   [This one run fine]

//End here

When I call  Proc_1 from the script editore it's work fine.

But I want to call  Proc_1 from Command Button or Text Box object, ETC.

Can any body please provide me the solution.

Thanks

SD

[#2]

I want to update one record in sql table with the help of macro on click of particular object. So it is must for me.

Thanks

SD

[marcus_sommer]

The IE plugin needs to be installed by the appropriate users and requirred therefore windows as OS which meant that mobile devices like smartphones or tablets don't work as well as apple machines (unless VM or dual-boot). Further you need to enable macro-execution within the qmc (server/system/security) but it's not sure that you get such macros to work.

Also possible is to use AJAX with extensions like:

Data2Webservice Object Extension

SQL Writeback from QlikView extension object.

- Marcus

[#4]

Hi Marcus,

Thanks for response.

But I don't know which IE Plugin I have to install. Can you please let me know?

One more question.

Today when I open the qvw file there is one dialogue box has appeare's. of which screen shot is attached.

Can you please let me know how to enable the check box of

Always use this option for documents from this Qlikview Server

So, that I can tick it.

And then upload on the server. So, that macro migth run at server level as well. which may resolved my problem.

Thanks

SD

[marcus_sommer]

You should install the plugin-version which comes with your server-installation in ... YourDrive:\YourServerFolder\Server\QlikViewClients\QlikViewPlugin. That the last check-box "Always .." is disabled had security reasons but I don't know which option is excactly responsible for this - see here the security tabs in user- and document security.

- Marcus

[#6]

Hi Marcus,

Thanks of your suggession. FYI, "\YourServerFolder\Server\QlikViewClients\QlikViewPlugin" folder already there with

some files which inculdes following files as well:-

1. QvPluginSetup.exe

2. QVPluginWin8andUp.exe

Any some more suggession can you please give me. So, that I can achieve my goal.

Thanks

SD

[marcus_sommer]

It depends from the OS of the users. QvPluginSetup.exe is for Win XP/Vista/7 and QVPluginWin8andUp.exe for Win 8/8.1/10.

- Marcus