FIX: ALIAS() & SELECT() Browse Results Not Consistent w/2.5xID: Q119902 2.60 | 2.60 MS-DOS | WINDOWS kbprg kbbuglist kbfixlist The information in this article applies to:
SYMPTOMSIn 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. STATUSMicrosoft 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 INFORMATIONSteps to Reproduce Problem1. 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 |