At 09:33 PM 6/06/2004 +0000, you wrote:

> > > What does ERRCODE = 100 mean?
> >
> > Usually it's "No more records". You also get this immediately when
> > the result set is empty. There are other possibilities, e.g. "Invalid
> > database key"; see the Language Reference, page 204-205.
> >
> > I's not really an error - real errors have negative numbers.
> >
>Hi Paul,
>
>So if no more records can be fetched IB_MONITOR shows
>ERRCODE = 100?

That's right. It's the standard SQLCODE for "End of Cursor". Positive
SQLCODE messages and zero are information codes. Error codes are
negative. The software generalises all of the codes - information and
error - as ERRCODE.

Within the negative SQLCODEs are GDSCODEs, always nine digits. These are
finer level error codes generated by the engine to cover every last thing
that can go wrong. They are not defined by the SQL standard but within the
software itself.

Both the SQLCODE and the GDSCODE (if there is one) get returned after an
SQL request, in the Status Array, AKA Status Vector. IBO reads the status
array and delivers the codes and their corresponding text (found in
firebird.msg) verbatim. That is what you see in the IB_Monitor.

I extracted a full list of SQLCODEs and GDSCODEs with their messages for
The Firebird Book. You can download a raw copy of it here:
http://www.ibobjects.com/docs/fb_1_5_errorcodes.zip

Looking at the "problems" you have been describing lately, I don't think
you actually have an SQL error with your SPs at all. It looks more like
you are trying to do something impossible with the output - like bringing a
singleton result into a grid component, for example, and calling Next or
Last on the result set.

That's why we aren't going to get anywhere with a solution until you tell
us what you are actually doing with this statement and its output.

Helen