PRB: "Attempt to Use FoxPro Function as an Array" in BROWSE

ID: Q114576

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for Macintosh, version 2.5b

SYMPTOMS

The following error message occurs during a BROWSE:

   Attempt to use FoxPro function as an array.

CAUSE

A command is being used on a field in the BROWSE.

RESOLUTION

Create a calculated field that uses the command. For an example, see "Workaround" in the "More Information" section below.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Use the CUSTOMER.DBF database file located in the TUTORIAL subdirectory.

   For example, if FoxPro is installed in a directory named FOXPROW on
   drive C, type the following command in the Command window:

      USE C:\FOXPROW\TUTORIAL\CUSTOMER

   example, type the following in the Command window:

      BROWSE FIELDS ALLTRIM(contact)

Workaround

Use a calculated field that calls the ALLTRIM() command. Instead of the BROWSE command shown in step 2 above, use the following command:

   BROWSE FIELDS TrimContact = ALLTRIM(contact)