KB157189 - FIX: MLINE() with Select-SQL Group By Clause Causes Error

Article ID: 157189

Article Last Modified on 10/16/2002

Microsoft Visual FoxPro 5.0 Standard Edition
Microsoft Visual FoxPro 5.0a

This article was previously published under Q157189

SYMPTOMS

If a SELECT-SQL query is grouped by a field that is displayed using the MLINE() command, then executing the statement produces the following error and a result set is not created:

SQL: Internal Error

WORKAROUND

You can use a combination of string functions and MEMOWIDTH as in this example:

   SELECT Fld1, LEFT(Fld2,set('MEMOWIDTH')) FROM test GROUP BY 2

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This has been corrected in Visual FoxPro 6.0.

MORE INFORMATION

Steps to Reproduce Behavior

Create and populate a table with a memo field as follows:

      CREATE TABLE test (Fld1 c(5), Fld2 m)
      INSERT INTO test VALUES("aaaaa","aaaaaaaaaaaaaaaaaaaa")
      INSERT INTO test VALUES("bbbbb","bbbbbbbbbbbbbbbbbbbb")

Issue the following command:

      SELECT Fld1, MLINE(Fld2,1) FROM test GROUP BY 2

Additional query words: kbvfp600fix

Keywords: kbbug kbfix kbprogramming KB157189