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

The information in this article applies to:

Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 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

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug kbProgramming KB157189 kbAudDeveloper