Subject Re: [IBO] Stored Procedure problem
Author Lucas Franzen

> the stored procedure and is populated afterward. There is however
> one field that is set to zero instead of the correct value when run
> from my application. When run from IBExpert, everything is
> populated correctly. I'm sure I'm doing something wrong, but I
> don't have a clue what.

Yes, now I'm almost clueless, too.

Either the stored proc also works from delphi (then you've got the same
result as you've got in IBExpert; but this is not the case) or it
doesn't work at all (then you should have got 0 in all fields, not just
in one; which isn't the case either).

But a stored proc that is working half way is - from my point of view -

It can't be a transaction problem; if it was you'd see either see the
original values or the new ones (but then ALL fields populated).
It can't be a problem in the procedure either.

So the only thing that comes to my mind is that you're working on two
different databases where the data in the tables or the procedure codes

Have you checked this and if so, have you checked the databases health?