FIX: FLDLIST() with Calculated Fields Returns Lower Case

Last reviewed: September 22, 1997
Article 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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.