Stored Procedure/Macro

[Anonymous]

Hi guys,

Is it possible to execute a stored procedure with a variable via a button within a document?  I've been trying to do this via a macro button but I can't figure this out

Thanks!

[#2]

Hi,

I tried to do so and it run successfully.

This is what I did-

1.Created a variable vdemo and set it's value to 0

2.Created a button and  allow it to change the value of variable(vdemo) to 1 using action on it.

3.Go to document properties and go to variable event triggers and apply action to run macro on changing value of variable.

4. Click on button and check value of variable, it will change to yes(as my macro is changing it)

It seems like this is the only way I know.

Attaching the required snapshots.

Cheers

Saurabh

[Anonymous]

Hi Saurabh,

Thanks very much for your help.

Would you be able to post a sample QVW file with these steps in please?

That would be a great help

[Anonymous]

Also i cannot see that your macro is running a stored procudure?  Would you be able to help with this as getting the macro to run the stored procedure is where i am struggling..

thanks!