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
BigAl66
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

Hi,

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

.ParamByName(.Params.Items[1].Name)...

I get the same error ( is my TMSStoredProc).

The stored procedure is defined like:

ALTER PROCEDURE [dbo].[]
@@xxx INT
AS
BEGIN
...

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...

Alex

AndreyZ

Post by AndreyZ » Tue 05 Jul 2011 09:43


Post Reply