Microsoft KB Archive/102452: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "&" to "&")
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{|
{|
|width="100%"|
|width="100%"|
= PRB: "Syntax Error"/"Variable Not Found" with BROWSE FIELDS /F =
= PRB: "Syntax Error"/"Variable Not Found" with BROWSE FIELDS /F =


'''ID: Q102452'''
'''ID: Q102452'''
Line 24: Line 24:
The slash symbol (/) is not a valid replacement for the colon (:) that is used with the forced validation option in the BROWSE FIELDS list.
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.
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.
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."
NOTE: This statement does not appear in the version 2.5 "Language Reference."


== RESOLUTION ==
== RESOLUTION ==
Line 41: Line 41:


<pre>  USE Customer
<pre>  USE Customer
   BROWSE FIELDS Company,Zip,Zip /V = Zip =&quot;76015&quot; /F ;
   BROWSE FIELDS Company,Zip,Zip /V = Zip ="76015" /F ;
       /E=&quot;Zip Code must be 76015&quot;
       /E="Zip Code must be 76015"
</pre>
</pre>
To correct this problem, replace the forward slash with a colon, as follows:
To correct this problem, replace the forward slash with a colon, as follows:
<pre>  USE Customer
<pre>  USE Customer
   BROWSE FIELDS Company,Zip,Zip /V = Zip =&quot;76015&quot; :F ;
   BROWSE FIELDS Company,Zip,Zip /V = Zip ="76015" :F ;
       /E = &quot;Zip Code must be 76015&quot;
       /E = "Zip Code must be 76015"
</pre>
</pre>
== REFERENCES ==
== REFERENCES ==


&quot;Language Reference,&quot; version 2.5, page L3-237
"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
Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a errmsg err msg docerr KBCategory: kbprg kberrmsg kbprb kbdocerr kbdocerr KBSubcategory: FxprgBrowse

Latest revision as of 12:24, 21 July 2020

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.