Microsoft KB Archive/119902

{| = FIX: ALIAS & SELECT Browse Results Not Consistent w/2.5x =
 * width="100%"|

ID: Q119902

2.60 | 2.60 MS-DOS | WINDOWS kbprg kbbuglist kbfixlist

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.

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