Thanks Svein,

I feel a little foolish, the decimal seperator was set to , instead of
. once I changed that it works.

Sorry for wasting your time :)

Cheers
Sam H

--- In IBObjects@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> 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
>