Field List Disable (-fldisable)

Use Field List Disable (-fldisable), which is a run-time parameter, to cause the AVM to ignore field lists in the r-code and fetch complete records.

Operating system and syntax UNIX / Windows -fldisable
Use with Maximum value Minimum value Single-user default Multi-user default
Client Session

Field lists restrict the fields returned from a record query. They allow you to retrieve only specified fields rather than all the fields of a record. Field lists are implemented with the FIELDS or EXCEPT options in FOR, DO PRESELECT, REPEAT PRESELECT, and DEFINE QUERY statements. They can improve performance over a network by enabling more records to fit into a single network message.

Note the difference between -fldisable and -rereadfields. The Field List Disable (-fldisable) option causes the AVM to ignore all field lists and to fetch the entire record for every query. The Reread Fields (-rereadfields) option causes the AVM to fetch the record with the specified fields, but then re-fetch the entire record if an ABL statement tries to reference a field that is not there. Also note that when the re-fetch happens, any FIND trigger is not run again.

For more information on -rereadfields see Reread Fields (-rereadfields).

For more information on field lists, see the Record phrase entry in ABL Reference.