21. 4GL Statement Glossary : ArrayLastRow()
 
Share this page                  
ArrayLastRow()
Counts non-deleted records in an array.
Syntax
returnfield = [callproc] arraylastrow(arr)
returnfield
Specifies the name of field to which the result is returned. Integer.
arr
Specifies the name of an array
Description
The arraylastrow() built-in procedure returns the number of undeleted records in the array you specify. It does this by counting the non-deleted records and returning the number of the record with the highest sequence number.
The procedure returns 0 if the array contains no non-deleted rows.
Example
To count the total number of employee records in the array emparray, and exclude any deleted records:
total = callproc arraylastrow (emparray);