FIX: SQL SELECT "Illegal Operation on Memo Field" Error

ID: Q88226

2.00 MS-DOS kbprg kbfixlist kbbuglist

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, version 2.0

SYMPTOMS

When an SQL SELECT statement has a WHERE clause that contains the TRIM function, and the TRIM function refers to an empty field, an "Illegal operation on a memo field" error is incorrectly generated.

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