PRB: "Unrecognized Phrase/Keyword" w/ Calculated BROWSE Field

ID: Q112351

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 when you are using a calculated field in a BROWSE:

   Unrecognized phrase/keyword in command.

CAUSE

The calculated field is not assigned to a calculated field name.

RESOLUTION

Assign a name to the calculated field.

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 in the Command window:

      USE C:\FOXPROW\TUTORIAL\CUSTOMER

2. Perform a BROWSE that attempts to concatenate the CITY and STATE fields,

   but doesn't assign the result to a calculated field name. Type the
   following in the Command window:

      BROWSE FIELDS city + state

   The error occurs.

To avoid this error, assign the concatenated fields to a calculated field name. Instead of using the BROWSE command shown above, use the following command:

   BROWSE FIELDS CityState = city + state

Additional reference words: FoxMac FoxDos FoxWin 2.50 2.50a 2.50b errmsg err msg KBCategory: kbprg kberrmsg kbprb KBSubcategory: FxprgBrowse