Subject Re: Strange behavior in stored procedure
Author vladman992000
--- In, "Alan McDonald" <alan@...> wrote:

> I wonder why SKIP 0?
> have you tried leaving this out? just use FIRST 1
> and using the FIRST clause without an order by.. I never do it. Are you
> looking for unreliable (unpredicable) results?

Thanks for your reply, Alan. I suspect you are correct, however I
found the problem in the end. It was not specifically in this stored
procedure after all but in the calling procedure that attempted to
create a log entry of what was going on in an audit trail. Thanks to
IBExpert, I was able to trace through the stored procedure and find
the error and fix it.

All is well now. Thanks to you and everyone else for their assistance.