Microsoft KB Archive/114576

{| = PRB: "Attempt to Use FoxPro Function as an Array" in BROWSE =
 * width="100%"|

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.

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 2. Perform a BROWSE that uses the ALLTRIM command on a field. For example, type the following in the Command window:

BROWSE FIELDS ALLTRIM(contact) The error will occur.

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) Additional reference words: FoxMac FoxDos FoxWin 2.50 2.50a 2.50b errmsg err msg KBCategory: kbprg kberrmsg kbprb KBSubcategory: FxprgBrowse
 * }