Accessing Parameter of TMSStoredProc by name...

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 11
Joined: Thu 10 Feb 2011 18:28
Location: Germany

Accessing Parameter of TMSStoredProc by name...

Post by BigAl66 » Tue 05 Jul 2011 07:29


I use a TMSStorecProc and try to change the parameters with ParamByName. I get an exeption "paramter not found". The params of the stord procedure are displayed as '@xxx'. When I try to access '@xxx' or 'xxx' I get the error. If I try


I get the same error ( is my TMSStoredProc).

The stored procedure is defined like:

@@xxx INT

I tried also using @xxx instead @@x.

What's going wrong? In the moment I access the parameter as ...Param[1].Value. But this is only a workaround. If the Parameters of the storec proc changes in the futere then (non) funny things can happen...



Post by AndreyZ » Tue 05 Jul 2011 09:43

Post Reply