[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
AFIELDS()

    AFIELDS() fills a series of arrays with fieldnames, field types, field
    lengths, and field decimals.

Syntax

    AFIELDS([<array1>[,<array2>[,<array3>[,<array4>]]]])

Arguments

    <array1> is the name of the array to fill with fieldnames.  Each
    element is character type.

    <array2> is the array to fill with the type of fields in <array1>.
    Each element is character type.

    <array3> is the array to fill with the widths of fields in <array1>.
    Each element is numeric type.

    <array4> is the array to fill with the number of decimals define for
    fields in <array1>.  Each element is numeric type.  If the field type
    is not numeric, the element is zero.

Returns

    An integer numeric value.

    AFIELDS() returns the number of fields or the length of the shortest
    array argument, whichever is less.  If no parameters are specified,
    AFIELDS() returns zero.

Usage

    AFIELDS() fills a series of arrays with the attributes of fields from
    the current work area and returns the number of elements filled with
    field information.  If there is no database file in USE, AFIELDS()
    returns zero.  The arrays passed correspond to fieldname, field type,
    field length, and field decimals if the field is numeric.

    To fill arrays for some attributes while ignoring others, pass a dummy
    variable.  For example, to obtain the fieldnames and corresponding
    field lengths only:

    DECLARE fname[FCOUNT()], ftype[FCOUNT()]
    dummy = ""                              
    AFIELDS(fname, dummy, ftype)            

See Also: ACHOICE ACOPY ADEL ADIR AFILL AINS ASCAN ASORT
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson