FIX: FLDLIST() with Calculated Fields Returns Lower Case

ID: Q124839

2.60 WINDOWS kbprg kbfixlist kbbuglist

The information in this article applies to:

Microsoft FoxPro for Windows, version 2.6

SYMPTOMS

When using FLDLIST() to return the field list of a SET FIELDS command, only the first letter of the ALIAS of calculated fields is returned in upper case. In Microsoft FoxPro for MS-DOS, the entire alias is returned in upper case.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in FoxPro version 2.6a for Windows.

MORE INFORMATION

Steps to Reproduce Problem

In the Command window execute the following commands:

   USE customer IN 1
   USE offices IN 2
   SELECT 2
   INDEX ON ono TAG ono
   SELECT 1
   SET RELATION TO ono INTO offices
   SET FIELDS GLOBAL
   SET FIELDS TO customer.company,msales=offices.ytdsales/12
   ?FLDLIST()

When you execute the FLDLIST() command, the desktop displays:

   CUSTOMER.COMPANY,MSALES=Offices.ytdsales/12

It should display:

   CUSTOMER.COMPANY,MSALES=OFFICES.YTDSALES/12

Additional reference words: FoxWin 2.60 buglist2.60 KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxotherGeneral Solution Type : kbfix

Last Reviewed: September 22, 1997