--- In firebird-support@yahoogroups.com, "Rick Debay" wrote:

>
> I think it's a 1.5 bug, as executing the procedure from DBW also fails

"no current record for fetch" is well-known optimizer bug and in some form exists even in latest Firebird versions. Usually it happens when one mixed two kind of JOIN syntax (implicit and explicit JOIN's) in the same query, iirc.

> but works if the stored procedure is stepped through under the DBW
> debugger.

There is no native debuggers for Firebird. All existing debuggers is emulators and can't work exactly same way as engine itself. Also, they have own mistakes in implementation. So, don't trust debuggers blindly :)

Regards,
Vlad

PS v1.5 is not developed for a long time, consider upgrade to the more recent version...