$FieldgroupOccurrence

From m204wiki
Revision as of 22:20, 12 December 2013 by JAL (talk | contribs) (Undo revision 66129 by JAL (talk))
Jump to navigation Jump to search

This function returns the current occurrence number of the field group. If the current field group has been deleted, $FIELDGROUPOCCURRENCE returns 0.

$FIELDGROUPOCCURRENCE is available as of Model 204 version 7.5.

Syntax

%num = $FIELDGROUPOCCURRENCE

Example

FOR EACH OCCURRENCE OF FIELDGROUP REDSOX PRINT $FIELDGROUPOCCURRENCE CALL CHANGINGPROC PRINT $FIELDGROUPOCCURRENCE END FOR

This example might print a different value before and after calling the CHANGINGPROC procedure, if that procedure inserted or deleted the field group occurrence before the current one.

Usage notes

  • In a large record, $FIELDGROUPOCCURRENCE is expensive. It intentionally scans from the start of the record, in case there were additions or deletions of the fieldgroup.

    For example, say that a record being processed in an FEO FIELDGROUP loop has thousands of occurrences of a fieldgroup named CORE. In this case, invoking $FIELDGROUPOCCURRENCE for each iteration of the loop will be prohibitively expensive, and you can save significant processing resources if you substitute a simple OCCURRENCE IN CORE statement for the $FIELDGROUPOCCURRENCE statement.