--- In IBObjects@yahoogroups.com, Paul Vinkenoog <paul@v...> wrote:

> Hi Constantijn,
>
> > IB_MONITOR shows an error with FETCH:
> >
> > /*-----------------------------------------
> > [ 6-6-2004 20:34:58 ]
> > FETCH
> > STMT_HANDLE = 14698260
> > FIELDS = [ Version 1 SQLd 1 SQLn 1
> > SYSDBA.RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = 'CHANGECODE
> > ' ]
> >
> > ERRCODE = 100
> > -------------------------------*/
> >
> > 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?
This means that I can't rely on IB_MONITOR output checking for
'ERRCODE = ' substrings? Does ERRCODE mean: ERRor CODE?
You mean that IB errorcodes are negative or are "real" ERRCODE's negative?
Are there IB_MONITOR MonitorGroups or StatementGroups that I shouldn't
include?

It's a bit confusion for me.