Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Append from command
Miscellaneous
Thread ID:
00512748
Message ID:
00512748
Views:
51
Hello All:
I used the append from command to insert record to a cursor from a ascii file. I do not know what did I do wrong that only two fields were insert to the cursor for each record. Please take a look of my codes and help:

CREATE CURSOR SOURCE(clEntity C(2), QT_ID C(7),clInsured C(81),;
clDBA C(30), clAddr1 C(30), clAddr2 C(30), clCity C(20),;
clState C(2), clZip C(5), qtPolicyNo C(9),;
qtEffDate D, qtExpDate D, RAgtName C(30),AG_ID C(9),;
RISKNUM N(1), calLocCity C(20), caLocState C(2), ;
caRiskYear C(4),caRiskMake C(20),caRiskVin C(17), ;
caBody C(15), caAddIns C(30),;
caAIType C(25), caFormID C(25))

append from test.txt delimited with ";"

The ascii file looks like this:
IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 1;LOWEVILLE ;NY;2000;FORD ;1FDWX37F9YEC89844 ;TRUCK ;
IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 2;LOWVILLE ;NY;1985;EBY ;1E9LG222XF1011240 ;TRAILER ;
IN;BUSHJ01 ;JOSEPH BUSH ; ;RTE 1 BOX 108A ; ;LOWVILLE ;NY;13367 ;TN276532 ;07/21/00;07/21/01;W.B. PAYNE CO., INC. ;0950990; 3;LOWEVILLE ;NY;2001;BARRETT ;1B9P2420X11014262 ;TRAILER ;CA0012 ;CA0022 ;CA0112 ;CA0225 ;CA2232 ;CA3107 ;CA9944 ;IL0017 ;IL0183 ;IL0185 ;INVOICE ;N2500 ;T006 ;T047 ;T217 ;T224 ;T237NY ;T344NY ;TD01NY ;TJ01NY ;
Next
Reply
Map
View

Click here to load this message in the networking platform