>>>Hi all, i just need to make an append from xfile, but my target table has a memo field in the position email, so if i use append from xfile only, this field doesn't be filled.
>Somebody knows how to fix this? i need to use the memo field because the column mail can be longer than 254 chars.
>
>thank you all.
>
>>try
>
>>INSERT INTO (ALIAS()) SELECT ... FROM xfile
>
>Hi Fabio, thanks, but i'm using the append from xfile because the xfile is a csv file (i forgot write it before), this file has 15 columns, the 10 column is the email and can be longer than 254 chars.
it cannot directly be done
SET TEXTMERGE TO MEMVAR cvsString ON NOSHOW
\aaaa,11.4,555,<<REPLICATE("x",300)>>
\bbbb,12.661,-557,<<REPLICATE("y",300)>>
SET TEXTMERGE TO
CREATE CURSOR TEST (F1 c(4),n1 N(10,3),I2 I,M1 M)
for k=1 to ALINES(aRecords,m.cvsString)
=ALINES(aFields,aRecords[m.k],",")
INSERT INTO (ALIAS()) FROM ARRAY aFields
NEXT
BROWSE
or do the same process with FGETS(,8192) or FREAD()