Use the OnCustomXXXX event and manually perform the operation with your own
TIB_DSQL component.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: <mmenaz@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, February 02, 2003 10:10 AM
Subject: [IBO] UpdateSQL, SP and a parameter


> 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