Subject | Re: Re[2]: [ib-support] Paradox/Float to Firebird/Numeric/Float ? |
---|---|
Author | Valdir Stiebe Junior |
Post date | 2003-01-24T13:33:57Z |
> That's my doubt too. I do not know how paradox (or even the BDE)Hi Carlos. We had to convert a Paradox (dBase3) data to our Firebird/IBX
> handle this. I would like to use the firebird datatype that has the
> most similar "handling" as Paradox-Float to avoid customers complaints
> about diferent results after the transition from Pdox to FB.
database.
We had problems because the old data was using something like numeric(10,2)
to currency and our database use (16,6). This generated a lot of rounding
problems. So we had to import the data using cast(old_field as
numeric(16,2)). This worked for us.
Valdir.