Just one quick question: What is defined as the decimal separator on the computer where you try to do the import and what is the setting of the property DecimalSeparat in your TIB_Import component? Some countries (e.g. Norway) by default use ',' rather than '.' as the decimal separator, and hence, we generally prefer <tab> as the column separator.

Note that I don't use TIB_Import myself, and don't know whether there is a problem with it or not. I would just expect Jason to at least have tested importing with the standard US decimal separator, so that errors are more likely to occur if used on a computer with e.g. the reginal settings that I'm used to.

Set

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of sshowl09
Sent: 23. august 2009 23:25
To: IBObjects@yahoogroups.com
Subject: [IBO] TIB_Import is not handling decimal/floating point values.

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