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

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, version 2.6
• Microsoft FoxPro for Windows, version 2.6

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.