cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to Execute Registered Query in Vbscript Macro

Mounika
MEGA Partner
MEGA Partner

Hello ,

I have written a Registered Query and Now I want to execute this query in Macro .

I know that we can use ExecuteSel command to execute a Query with parameters in Macro 

But the one which i wanted to execute doesn't have any Parameters

 

Could some one help with the syntax to be used here .

 

Thanks

Mounika

2 Replies

marte_jma
Contributor

Hello Mounika,

 

Maybe you solved your issue, but I hope this will be helpful for other people. I've found how execute a query without parameters from a VBscript :

 

set cColl = GetSelection(oQuery.GetProp("_Select"))

 

cColl contains the query result.

oguimard
Retired

Hello,

 

There are several example in HOPEX in the VB script macro. Search on the following item :

  1. oRoot.CurrentEnvironment.GetMacro("")
  2. .CallFunction("")