Page 1 of 1

Getting MSQuery Parameters at Run-time

Posted: Tue 09 Dec 2008 15:31
by jeanlaurent
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

Posted: Thu 11 Dec 2008 12:48
by Dimon
To get parameters of a stored procedure by TMSQuery, you should use the CreateProcCall method, like this:

Code: Select all

MSQuery.CreateProcCall(sp_name);