trigger retrieveSequential

Trigger that retrieves the next occurrence in the database with a primary key value greater than the current one.

Description

This trigger is only useful in forms in which the Behavior property is set to Record. Record behavior allows only a single occurrence of the outer entity. A retrieve statement in this trigger retrieves the next occurrence in the database with a primary key value greater than the current one; that is, the occurrence that would appear next in the sort order.

Note:  Uniface does not support this trigger for all DBMSs. For more information, see Data Retrieval Support.

If ProcScript in this trigger activates the read trigger and a negative value in the activated read trigger is returned, I/O processing is terminated after the read trigger completes.

By default, the retrieveSequential trigger contains the following code:

trigger retrieveSequential
  retrieve
  if ($status < 0)
     message $text(1762) ;error
  endif
end; retrieveSequential