Subject Re: [ib-support] to change the decimal separator
Author Gregor Ernst
Thank you Martijn.
My Question is: How do I Change it?
I am getting an ASCII-File containing SQL Statments Like Insert into Artikel
(ARTno,Price) Values ('12345','123,22')
The Result is, that this Article now has Price of 12322 instead of 123.22.
The Systems I work with runs in Germany and the OS uses the ',' as the
decimal separator.
Is there a possability to change the separator Character? I don't want to
program a Stringconversion for the hole Insertscript.

Gregor Ernst



""Martijn Tonies"" <m.tonies@...> schrieb im Newsbeitrag
news:003701c2a02c$7c171d50$0a02a8c0@seal...
> Hi,
>
> Why don't you change it at the client-side?
>
> > I am looking for a command to change the decimal separator. I am getting
> an
> > insert string with "," as decimal separotor.
> > Can I tell IB to accept this as the separator or do I have to convert
the
> > source?
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> Firebird Workbench - the developer tool for Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>