Microsoft KB Archive/102452

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

PRB: "Syntax Error"/"Variable Not Found" with BROWSE FIELDS /F

ID: Q102452

The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5 and 2.5a
  • Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SYMPTOMS

Using a forward slash (/) as a replacement for the colon that is used in conjunction with the forced validation (:F) option produces one of the following error messages:

   Syntax error

   -or-

   Variable not found

CAUSE

The slash symbol (/) is not a valid replacement for the colon (:) that is used with the forced validation option in the BROWSE FIELDS list.

According to Page C3-173 in the "Commands & Functions" manual for FoxPro version 2.0 for MS-DOS, the colon delimiter used in the various options associated with the BROWSE FIELDS clause can alternately be replaced with a forward slash. This statement is correct for all the options except the forced validation option.

This documentation error occurs on Page C3-173 of the "Commands & Functions" manual for FoxPro version 2.0 for MS-DOS.

NOTE: This statement does not appear in the version 2.5 "Language Reference."

RESOLUTION

Use a colon instead of a forward slash when you are using the forced validation option.

MORE INFORMATION

Steps to Reproduce Problem

The following code will cause an error:

   USE Customer
   BROWSE FIELDS Company,Zip,Zip /V = Zip ="76015" /F ;
      /E="Zip Code must be 76015"

To correct this problem, replace the forward slash with a colon, as follows:

   USE Customer
   BROWSE FIELDS Company,Zip,Zip /V = Zip ="76015" :F ;
      /E = "Zip Code must be 76015"

REFERENCES

"Language Reference," version 2.5, page L3-237

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a errmsg err msg docerr KBCategory: kbprg kberrmsg kbprb kbdocerr kbdocerr KBSubcategory: FxprgBrowse


Last Reviewed: June 27, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.