FIX: ORDER BY Clause Ignored in SQL SELECT Statement

ID: Q88213

2.00 MS-DOS kbprg kbfixlist kbbuglist

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, version 2.0

SYMPTOMS

In an SQL SELECT statement that has an ORDER BY <field> clause, a GROUP BY <field> clause, and a UNION clause, the ORDER BY clause is ignored.

STATUS

Microsoft has confirmed this to be a problem in Microsoft FoxPro version 2.0 for MS-DOS. This problem was corrected in Microsoft FoxPro version 2.0 for MS-DOS released March 25, 1992.

Additional reference words: FoxDos buglist2.00 fixlist2.00 2.00 KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: Solution Type : kbfix

Last Reviewed: October 14, 1997