Thanks Tracy
I know that SA_JOB is the 58th field in the table
FIELD(58) returns SA_JOB
Paul
-----Original Message-----
From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Tracy Pearson
Sent: 23 November 2020 14:19
To: profoxt...@leafe.com
Subject: RE: Problem with APPEND FROM <Filename> TYPE DELIMITED
Sent by an external sender
------------------------------
Hi Paul,
cmd = "CREATE CURSOR mytable ("
FOR ii = 1 TO 66
cmd = cmd + "F" + TRANSFORM(ii) + " c(10)"
IF ii < 66
cmd = cmd + ","
ENDIF
NEXT
cmd = cmd + ")"
&cmd.
Select MyTable
APPEND FROM MyFile.CSV TYPE DELIMITED
BROWSE LAST NOWAIT
F58 gets the value LEITH
I don't have a reason why your 58th field is being populated.
List Structure of MyTable will give you the field number next to the field
name. This may help you verify your table.
HTH,
Tracy
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton
Sent: Monday, November 23, 2020 8:15 AM
To: profoxt...@leafe.com
Subject: Problem with APPEND FROM <Filename> TYPE DELIMITED
Hi all
I have a CSV file (MyFile.CSV) with a single line that looks like this:
FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,,,,,N,,,,,,,8300,,-15,,
-3,,,H,S,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,LEITH
You can verify for yourselves that LEITH is the 58th column. I have a table
(MyTable.DBF) with 66 fields and Field(58) returns SA_JOB
The following fails to populate SA_JOB
Select MyTable
APPEND FROM MyFile.CSV TYPE DELIMITED
All the other columns are correct in the table. I am completely stumped so any
help would be much appreciated.
Paul Newton
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/sn1pr02mb374373ec12062a69116b16f3a1...@sn1pr02mb3743.namprd02.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
