Microsoft KB Archive/120764

{| = PRB: Same Field Can Be Repeated in SET FIELDS List =
 * width="100%"|

ID: Q120764

The information in this article applies to:


 * Microsoft FoxPro for Windows, versions 2.6, 2.6a
 * Microsoft FoxPro for MS-DOS, versions 2.6, 2.6a
 * Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS
A field list can contain the same field more than once.

CAUSE
The SET FIELDS command is GLOBAL.

STATUS
This behavior is by design.

MORE INFORMATION
The SET FIELDS GLOBAL command was added for dBASE compatibility. In dBASE, a field list can contain the same field more than once.

Steps to Reproduce Behavior
Run the following code in a program or the Command window:

USE SYS(2004) + "\tutorial\customer.dbf" SET FIELDS GLOBAL SET FIELDS TO  SET FIELDS TO cno SET FIELDS TO cno BROWSE Note that the CNO field is displayed twice. Additional reference words: FoxWin FoxMac FoxDos 2.60 2.60a duplicate second multiple multiple repeated recurring re-occuring KBCategory: kbprg kbprb KBSubcategory: FxprgBrowse
 * }