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

[marcus_sommer]

It's not quite clear what do you want to do. But I think it's not possible in this way. If you want to query external data from the gui you could use Direct Discovery and if you want to write back into a database you should look here: https://community.qlik.com/search.jspa?q=write+back&type=document

- Marcus

[#3]

Hi Marcus,

Thanks for quick response.

Let me explain you my requirement.

The way we create the macro(As Function/Sub)  in EDIT MODULE and then we call on verious trigger type such, as on open, on select any column or object, on close, etc.

Same way the function/proc/sub which I had created as Qlikview Editor as show above. I want to call same on trigger type such as on open, close, select any column, or object, ETC.

I hope you understand

Thanks

SD

[marcus_sommer]

Routines which are created within the script couldn't be called on the gui - you could only call macro-routines but the most things should be possible with them.

- Marcus

[#5]

I had created the macro in qvw which run's fine in desktop. But same QVW when I upload on server it doesn't work.

can you please let me know how I should configure it.

Thanks

SD

[marcus_sommer]

With the AJAX client macros won't work - with the IE plugin the most macros should work.

- Marcus

[#7]

I am new in this. Can you please help me to knew AJAX client and IE Plugin. I knew this much thatelp  if macro run in qlikview desktop it should work in qlikview server as well. However which is not working

is it possible for you to send sample qvw file and help me to configure it in qlikview server.

Thanks

SD

[marcus_sommer]

Before going on, please read this: Macros are Bad and think are there really no other ways to get your solution?

- Marcus

[#9]

I knew it slow down the application. But for me it is very important. It will be great helpful if you can help me on this problem.

Thanks

SD

[marcus_sommer]

A possible slow-down isn't the main-fact why the use of macros should be considered carefully. What does your macro(s)?

- Marcus