FIX: ALIAS() & SELECT() Browse Results Not Consistent w/2.5x

ID: Q119902

2.60 | 2.60 MS-DOS | WINDOWS kbprg kbbuglist kbfixlist

The information in this article applies to:

SYMPTOMS

In FoxPro 2.6 for Windows and MS-DOS, the ALIAS() and SELECT() functions return values that are inconsistent with the values returned in previous versions of the product.

STATUS

Microsoft has confirmed this to be a problem in FoxPro version 2.6 for Windows and MS-DOS. This problem was corrected in FoxPro version 2.6a for Windows and MS-DOS.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a new program file containing the following code:

      USE customer
      SELECT 0
      USE invoices
      SET ORDER TO cno
      SELECT customer
      SET RELATION TO cno INTO invoices

      BROWSE FIELDS customer.cno :W=x(), invoices .ino :W=x()

      PROCEDURE x
      WAIT WINDOW NOWAIT LTRIM(STR(SELECT())) +': ' + ALIAS()

2. Run the program in FoxPro version 2.5x for Windows or FoxPro version
   2.5x for MS-DOS. After the Browse window appears, move the cursor from
   the CNO column to the INO column. The values returned by SELECT() and
   ALIAS() will reflect the name of the parent table regardless of the
   column that currently has the focus.

3. Run the program in FoxPro version 2.6 for Windows or FoxPro version 2.6
   for MS-DOS. Again, move the cursor from one column to another. The
   values returned by SELECT() and ALIAS() reflect the name of the table to
   which the current column belongs.

Additional reference words: FoxDos FoxWin 2.60 buglist2.60 fixlist2.60a KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxprgBrowse Solution Type : kbfix

Last Reviewed: October 20, 1997