This project has moved and is read-only. For the latest updates, please go here.

Any way to call SP with dynamically determined param?

Topics: Developer Forum, User Forum
Dec 20, 2011 at 6:43 PM



Regular call to SP works great

I'd like to create an action which can pass attributes of current cell for further Rowset Action

I wonder if it's possible to call SP and pass param something like:


'call SQLQuery.ExecuteSql(    "Provider= Sqlncli10;server=localhost;database=Test;trusted_connection=yes"    ,"exec usp_OLAPTest ASSP.ASStoredProcs.FindCurrentMembers.FindCurrentTuple()")'

or maybe there is ome workaround, otherwise it seems that I'd have to invoke this call from Excel VBA macro

Many Thanx