Subject RE: [firebird-support] Clear Query Cache Firebird 2.1
Author Alan McDonald
> Alan,
>
> > > Sounds as though you are using some tool like IBExpert or similar,
> that
> > > can simulate execution of a SP. It's not executing it at the
> server.
> >
> > incorrect. it gets executed at the server, line by line, not as a
> block.
> > it maintains running parameters/variables for each statement.
>
> Firebird currently has no debugging API.
>
> It is, therefore, impossible for IBExpert to be executing the logic one
> statement at a time.
>
>
> IBExpert has created its own FB "engine" for the purposes of debugging
> SP/Triggers.
>
>
> Sean
Helen's claim was that the statements are not executed at the server. They
are indeed. The engine to which you refer, breaks open the SP block and
fires them at the server one by one. The engine maintains the input
variables and return variables of each statement.
It's as good as it gets with no debugging API.
Alan