info("fieldcount")
info("fieldcount")

The info(“fieldcount”) function returns the number of fields in the current database.

Description

This function returns the number of fields in the current database. For example, you could use it to test to see if the current field is the last field of the database.

    info("fieldnumber")=info("fieldcount") ☞ true if currently on last field

Here is an example that shows how to create a procedure that scans every field in the database from left to right, performing some operation on each field.

    for fn,1,info("fieldcount")
        field fn+0
        // DO SOMETHING FOR EACH FIELD
    endloop

See Also

- emptyfield -- tells Panorama to move to the next available (empty) field in a series of line item fields.
- field -- tells Panorama to move to the specified field for the current record.
- fieldblueprint -- creates blueprint code for the specified field.
- info("fieldname") -- returns the name of the current field.
- info("fieldnumber") -- returns the number of the current field (starting from 1).
- info("fields") -- returns a carriage return delimited list of fields in the current database.
- listchoices( -- builds a text array containing a list of all the values stored in a specified field.
- recalculatefield -- recalculates all values in current field based on field's formula (selected records only).
- runfieldcode -- runs the automatic code associated with the specified field.
- uniqueid( -- generates ID codes with a text root and a numeric suffix (for example `Jeff261`).

History

Version | Status | Notes
10.0 | New | New in this version.