No, not a typo :) Here I wrote a sample, just to make clear the situation.
In the real query field names are taken with a copy&paste, and double
checked, and with a convention that make them easy to read for me
(field ESERCIZIO_ID, param name P_ESERCIZIO_ID...)
Anyway, I've checked again, the param is typed right. Also wondering
why the error is risen opening the query with parameters assigned and
teh UpdateSQL defines, and not while inserting or if the UpdateSQL is
blanked.
Anyway, IBO seems not to find the binding between the updateslq fields
and the select part of the query, ignoring parameters :(
regards
Marco Menardi

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 05:10 PM 2/02/2003 +0000, you wrote:
> >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?
>
> Could it be a typo?
> myparm or myparAm?
>
> Helen