bingo.SDFImport problem - rows with empty values

[Colin]

Hi,
I'm very much a Bingo (and SQL) novice, so I'm hopeing there's an easy
solution. I am trying to load an sfd file into MSSQL Server as per
the instructions. However, there are some empty rows (in columns set
up in the create table command) of datatype float. However, when I
try to import, I get an error saying there is a data type mismatch:

"The given value of type String from the data source cannot be
converted to type float of the specified target column. --->
System.FormatException: Failed to convert parameter value from a
String to a Double. ---> System.FormatException: Input string was not
in a correct format.
System.FormatException: " etc.

I strongly suspect that this is due to empty rows in a single column,
as when I remove them, the data imports as expected; likewise if I set
the table up with the type as nvarchar, the data imports including the
empty cells.

This behaviour seems strange to me as the column itself should accept
null values.

Any ideas would be gratefully appreciated. I'm using Bingosqlserver
1.6.2.

Kind reagrds,
Colin

[Mikhail Rybalkin]

[Mikhail Rybalkin]

Hi Colin,

Thank you for this bug report! I reproduced this behavior and we are going to fix this issue. As a temporary solution you can define same columns with string datatype, and then replace all empty strings with Null, and then change column type to float.

PS:  I posted empty message by mistake.

Best regards,

Mikhail

On Thursday, May 31, 2012 5:47:47 AM UTC-7, Colin wrote: