>Hi all,
>
>I have text files with lines of data and I wanted to copy them line by line to a memo field of a table, 1st line go to 1st record, 2nd line go to 2nd record. I have tried the following codes but somehow when the length of the line exceeds 50, it will append the following characters into 2nd record. Any idea?
>
>

>
>CREATE CURSOR lctest (mdata m)
>nline = MEMLINES(FILETOSTR(TRANSFORM(lcfile))) && lcfile = file name
>	
>FOR i=1 TO nline
>   INSERT INTO lctest VALUES (MLINE(FILETOSTR(TRANSFORM(lcfile)),i))
>ENDFOR
>
>

Increase the SET MEMOWIDTH value
And by the way, copy the file to a memory variable, it will be much faster

CREATE CURSOR lctest (mdata m)
lcText=FILETOSTR(TRANSFORM(lcfile))
nline = MEMLINES(lcText)
	
FOR i=1 TO nline
   INSERT INTO lctest VALUES (MLINE(lcText,i))
ENDFOR