Microsoft KB Archive/124839

{| = FIX: FLDLIST with Calculated Fields Returns Lower Case =
 * width="100%"|

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.

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
 * }