> I am developing stored procedures that are used in queries. It looks
> like my test queries do not use the output of the newest version of my
> stored procedure, but takes the result from the "query result cache" of
> the database.
>
>

I assume you mean selectable SPs???

do you disconnect and reconnect the query client each time you modify the
SP? otherwise the client will continue to use the SP as it was when they
started using it.
Alan

>
> Stepping the procedure returns the expected results!

this is because IBE uses a new transaction when debugging (stepping)

>
> Does the altering of stored procedure not clear the corresponding query
> cache?
>
> Is there a command to clear the cache or to force a query to generate
> new results?
>
> I am using Firebird Version "WI-V2.1.2.18118 Firebird 2.1" and IBExpert
> 2009.03.25
>
> Christian
>