Getting MSQuery Parameters at Run-time

jeanlaurent · Post by **jeanlaurent** » Tue 09 Dec 2008 15:31

hi,

We migrate an application from BDE to SDAC

In many Queries Stored Proc are used to get data. The problem is that we are working with a test database and not all stored proc are present in the test database. So is there a way to get the Query parameters at run time in the same way than TMSStoredProc (By setting Stored proc name) ?

Thank you

Jean-Laurent

Dimon · Post by **Dimon** » Thu 11 Dec 2008 12:48

To get parameters of a stored procedure by TMSQuery, you should use the CreateProcCall method, like this:

Code: Select all

MSQuery.CreateProcCall(sp_name);