Accessing Parameter of TMSStoredProc by name...
Posted: 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
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