Dan, I forgot to mention that the LOAD command disregards COMPUTED columns. So if you have a table with 35 columns, 5 of which are computed, then the load should only contain 30 columns.
Jan -----Original Message----- From: Dan <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 11 Feb 2009 16:34:21 -0500 Subject: [RBASE-L] - Incorrect Number of values (Load Command) Hi folks, I am having trouble with the LOAD command. I have a file from the bank that is a .CSV file If I click on the file, xcel opens it correctly as a 32 column file with data all correct. I created a table with (at first only 32) 32 columns All TEXT values and did a LOAD (tablename) from (filename) as CSV (yes I used correct table names and file names. I get the error "Incorrect number of values for this table ( 118)" for each row in the file. I added 15 more columns to see if that would help but no dice. All columns are TEXT and large enough to hold data. Any ideas? A row of the data looks like this: (there are 523 rows) 1/27/2009,15:52:55,Batch List,H0049021,"JPMorgan Chase Bank, N.A.",Vredevoogd Heating a,VREDEVOOGD,VRE,13452319312,Customer Debits,DBT,Maintenance Agreements,1/15/2009,1,Submitted,FILE ACCEPTED,MONICA SCOTT,SA10853,$13.00 ,D,72403473,2153876053,C,59765,,10927,"$8,143.47 ",$0.00 ,$0.00 ,512,0,0 Oh I am using 7.5.25.30324 (and yes I will be upgrading to Turbo ASAP) Thanks, Dan
