--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> mlq97 wrote:
> > So the problem seems to relate to the context in which it is called.
> > But if so, what could be causing this error message? Why would the
> > same update query sometimes work and other times show this parse error
> > when in both cases the variables seem correctly set and the
> > procedure's single input parameter is clearly OK?
>
> Since Firebird itself doesn't have a debugger, maybe you should tell us
> which tool you're using to debug.
>
> --
> Milan Babuskov
> http://www.guacosoft.com
>

I am using IBExpert.
I noticed that the stored procedure in which this query is contained
was not actually being called. I have now fixed this so it is being
called and my program now works correctly. However I am still puzzled
as to why the debugger seems to be behaving strangely in this context.

Mitch