FreeTDS Development Group

["Wilson, John" <John.Wilson AT Savvis.net>]

Bill,
Thanks...I have replicated the problem and have verified
that freebcp is not accepting NULL fields.  BTW, I had 
forgotten to put that info in the last email, the 
varchar(255) and three floats allow NULL.


-----Original Message-----
From: Thompson, Bill D (London) [mailto:ThompBil AT exchange.uk.ml.com]
Sent: Wednesday, October 23, 2002 1:47 AM
To: TDS Development Group
Subject: [freetds] Re: need some help with freebcp


Hi John,

I have managed to reproduce your problem.

I defined the table you describe:

create table xxbcp 
( col1 numeric(10,0), 
  col2 datetime, 
  col3 varchar(255), 
  col4 float, 
  col5 float, 
  col6 float, 
  col7 int)

I created a file of data using cut'n'paste from your mail. 
I used <tab> column separators (as that is what is required with the -c
format of bcp) . 
I noticed the data for the varchar(255) column was missing so I put 2 <tab>s
between the datetime value and the 1st float value (to indicate an empty
field). 

Hey Presto! I got the same results. 

I thought it might be the datetime format you used, so I changed it to one I
know works, but that made no difference. 

Next I put a value into the varchar(255) column data, and It started
working!

So, It looks like we have a problem with empty column data. 

Can you reproduce my results, and confirm I'm on the right track ?

I'll look into it in the meantime