Microsoft KB Archive/157189

= FIX: MLINE with Select-SQL Group By Clause Causes Error =

Article ID: 157189

Article Last Modified on 10/16/2002

-

APPLIES TO


 * 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.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.