ExecuteSQL in combination with other methods use?

Topics: Developer Forum, User Forum
Dec 27, 2011 at 2:54 PM

Hi,

 

Does anyone know how to use "executesql" in combination with other useful methods?

I found following on the main page:

executesql method:

"This routine would be a useful starting point for developing a custom rowset action, possibly integrating it with code from FindCurrentMembers to generate some SQL based on the current context"

It'd be great to be able to combine those two to send a query about "selected cell"

 

Thank You

 

S

 

Coordinator
Dec 31, 2011 at 7:16 AM

While it was an interesting concept it turns out that actions execute in a separate context, so it's not possible to do this. You have to pass any context information into the action as a parameter, you can't use the same techniques used in FindCurrentMembers.