ID: Q119902
2.60 | 2.60 MS-DOS | WINDOWS kbprg kbbuglist kbfixlist
The information in this article applies to:
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.
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.
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