Hi all

I have not been working with VFP in a while.
There is a pretty simple thing I'm stumbling with and I need your input.

CREATE CURSOR MyCursor (MyMemo M)
APPEND BLANK 
*-- This fails, it is just a long string
replace MyCursor.MyMemo WITH [,CR-B93748B-4,EG-5630H3D,SE-5630-866,RA-RI-41135,,CM-C4252-030,CM-C4255-030,AA-3503750,AA-4003750,AA-350350SL,AC-4B1946H-STD,AC-6B8100HX-STD,AC-91338-STD,AP-100-9905,JE-S346250316CU,JE-SS,JE-S345000316CS,KB-CR4032AM-10,KB-CR429AM-STD,KB-CR4287AM-50,KB-CR809AM-30,KB-CR848-10,KB-CR850-10X]
*-- This works, same string, divided in two
replace MyCursor.MyMemo WITH [,CR-B93748B-4,EG-5630H3D,SE-5630-866,RA-RI-41135,,CM-C4252-030,CM-C4255-030,AA-3503750,AA-4003750,AA-350350SL,AC-4B1946H-STD,AC-6B8100HX-STD,] + ;
[AC-91338-STD,AP-100-9905,JE-S346250316CU,JE-SS,JE-S345000316CS,KB-CR4032AM-10,KB-CR429AM-STD,KB-CR4287AM-50,KB-CR809AM-30,KB-CR848-10,KB-CR850-10X]

Have something changed on the string lenght allowed?

The problem is, I'm using VFPOLEDB and sending this command

update invent set relatedItm = ',CR-B93748B-4,EG-5630H3D,SE-5630-866,RA-RI-41135,,CM-C4252-030,CM-C4255-030,AA-3503750,AA-4003750,AA-350350SL,AC-4B1946H-STD,AC-6B8100HX-STD,AC-91338-STD,AP-100-9905,JE-S346250316CU,JE-SS,JE-S345000316CS,KB-CR4032AM-10,KB-CR429AM-STD,KB-CR4287AM-50,KB-CR809AM-30,KB-CR848-10,KB-CR850-10X',lastaction='M' where item_no = 'WI-K544M87'

The command is originally created like this

 comm.CommandText = "update invent set relatedItm = '" & Me.UltraTextEditor1.Text.Trim & "'" & _
                                ",lastaction='M' where item_no = '" & sItem.Trim & "'"

"invent" is a Memo field.
How I can make this work?

Many thanks in advance,