Hi,

Thanks for the help I have had from this group in the past, I have a couple of TIB_Import issues on the go at the moment.

This latest one is to do with decimal/floating point values.

I have a table with a FLOAT column, when i use TIB_Import to load a CSV into it I get this error :
'1223.546' is not a valid floating point value

I have tried changing the type of the database column to Decimal, numeric and have tried changing precision/scale.

I have also tried changing the value. Whole numbers get in ok but any value with a decimal place causes this error.

Yet the column is a FLOAT and using a database client I can insert the value.

I think the issue is in the TIB_Import.

Below is data from the csv.

2002,MELTON,med,Medium,15-50 Stores,1090,12/21/2007,ELLEN,HUNTER,February,212

2003,RINGWOOD NORTH,lrg,Large,50+ Stores,1795,08/20/2009,NAOMI,WOODS,July,5253

2004,BALGA,sml,Small,0-15 Stores,1697,07/26/2007,RACHEL,BREWER,March,1223.546


'1223.546' is not a valid floating point value