throwNrfEofExceptions

If the throwNrfEofExceptions property is set to YES, a soft error (typically "no record found" or "end of file") causes an exception to be thrown, allowing you to handle the exception. If the property is set to NO (the default), no exception is thrown, but your code can respond:
  • If a get statement with or without a position option retrieves data into a record, use the is or not operator to test for soft errors. Here are skeletal examples:
    // after a get statement, test for no record found
    get myRecord01;
    if ( myRecord01 is noRecordFound ) 
      // respond
    end
    
    // in relation to a get statement with a next option, 
    // test for end of file
    get next myRecord02;
    while ( myRecord02 not endOfFile )
       // process the record
       get next myRecord02;
    end
  • After a SQL SELECT statement, check the value of the sysVar.sqldata.sqlcode field:
     if ( sysVar.sqldata.sqlcode == 100 )
       // respond
     end

For further details, see "Exception handling."