Subject | UpdateSQL, SP and a parameter |
---|---|
Author | Marco Menardi <mmenaz@lycosmail.com> |
Post date | 2003-02-02T17:10:17Z |
I've a query like:
select a, b, c from myselectproc(:myparm)
the UpdateSQL is like:
execute procedure myspupdate( :myparam, :a, :b, :c)
if I assign the parameter in BeforeOpen event, or in the query editor
I prepare the query, assign parameters and then open, I get the
following error:
"Invalid custom DML column reference: myparam."
how can I use (assign) a parameter to the update stored procedure, and
how avoid this error?
thanks
Marco Menardi
select a, b, c from myselectproc(:myparm)
the UpdateSQL is like:
execute procedure myspupdate( :myparam, :a, :b, :c)
if I assign the parameter in BeforeOpen event, or in the query editor
I prepare the query, assign parameters and then open, I get the
following error:
"Invalid custom DML column reference: myparam."
how can I use (assign) a parameter to the update stored procedure, and
how avoid this error?
thanks
Marco Menardi