Getting MSQuery Parameters at Run-time

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jeanlaurent
Posts: 1
Joined: Tue 09 Dec 2008 14:23

Getting MSQuery Parameters at Run-time

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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);

Post Reply