Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from ... target table has a memo field
Message
From
14/02/2006 09:59:37
 
 
To
14/02/2006 09:37:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01096125
Message ID:
01096143
Views:
26
Thanks Fabio, this is it. :) i decided by fgets.

>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,<>
\bbbb,12.661,-557,<>
>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(aRecords,FILETOSTR("namefile"))
=ALINES(aFields,aRecords[m.k],",")
INSERT INTO (ALIAS()) FROM ARRAY aFields
>NEXT
>BROWSE
>or do the same process with FGETS(,8192) or FREAD()
John Harold Belalcázar Lozano
Associate Director Of Development
http://www.belvicto.co/
jhbelalc@gmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform