FWD » Core Development » Database

The set of get{First|Next|Last|Previous} methods should return:

• ? (unknown) if the query object handle is invalid;
• yes if a new (virtual) row is found and available;
• no if the query is not open or the next record cannot be found.

At this moment they return no if case of error conditions and yes otherwise (regardless if a new row is available or not). This means that if a procedure uses them to end a loop, it will break when trying to access an inexistent off-end row of the query.

Alternative working form for

IF (NOT qh:GET-NEXT())
   THEN ... 

is to rewrite as:

qh:GET-NEXT().
IF (qh:QUERY-OFF-END)
   THEN ...

This may give the fix solution to return in GET-NEXT the !QUERY-OFF-END.