Thanks Man-wai
Field 58 is SA_JOB C(8)
Paul -----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Man-wai Chang Sent: 23 November 2020 14:19 To: profoxtech@leafe.com Subject: [SUSPECTED SPAM] Re: Problem with APPEND FROM <Filename> TYPE DELIMITED
Sent by an external sender ------------------------------
What's the structure of your DBF, notably the definition of the 58th field?
On Mon, Nov 23, 2020 at 9:14 PM Paul Newton Paul.Newton@pegasus.co.uk wrote:
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.
-- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!
[excessive quoting removed by server]