I knew there got to be a reason why I stay with VFP 6 <g>.
>Hi Igor,
>
>Your code runs w/o problem in VFP6SP5 but generates an error in VFP7/8. Looks like this bug was introduced in VFP7 and carried into VFP8.
>
>>I think I ran into a bug in VFP, as decribed below. I wonder whether anybody knows a workaround.
>>
>>The problem is that SQL SELECT .... INTO CURSOR generates an error (String is too long) if memo field used to create new column in destination cursor is a part of expression (ALLTRIM, TRANSFORM, etc.).
>>
>>Steps to reproduce:
>>
>>CREATE CURSOR a1 (bb M)
>>APPEND BLANK IN a1
>>REPLACE bb WITH REPLICATE('a', 2000) IN a1
>>
>>Now, the following works:
>>
>>SELECT a1.bb as dd from a1 INTO CURSOR c1
>>
>>While, the following generates an error:
>>
>>SELECT TRANSFORM(a1.bb) as dd from a1 INTO CURSOR c1
>>
>>This error exists if any function used against the originam memo column: TRANSFORM, ALLTRIL, RTRIM, etc.
>>
>>Thank you,
>>Igor.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham