Subject Re: [ib-support] Re: Strange roundings in IB-5.6
Author Bengt Skogvall
Javi,

please note that IB 5.5 has some very dangerous bugs in it that can destroy
your database. All of a sudden, the IB 5.5 engine would crash when you open
the hit GDB. Same with Backup. Remedy: Desinstall 5.5. Install 5.6. Set
sweep interval to 0 with gfix. Backup your database with "Disable Garbage
Collection" option. Restore it. Relax.

Regards,
Bengt Skogvall


----- Original Message -----
From: "Entrebytes S.L." <ebytes@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 03, 2002 1:41 PM
Subject: Re: [ib-support] Re: Strange roundings in IB-5.6


> In fact , i have to mantain installations with IB 5.5 , 5.6 ,6.0 , FB 1.0
> and in SCO , Linux , Win98 , NT and 2000..... with the same database and
> client.... ranging from 2 to 60+ users....
>
> Sometimes i fancy how many time will pass before i go insane..
>
> Javi
> EntreBytes S.L.
> Ontenient , Spain
> ERP Development.
> ----- Original Message -----
> From: "Martijn Tonies" <martijn@...>
> To: <ib-support@yahoogroups.com>
> Sent: Wednesday, April 03, 2002 1:22 PM
> Subject: RE: [ib-support] Re: Strange roundings in IB-5.6
>
>
> > Hi,
> >
> > Oops - totally true... I usually forget about IB < 6 :)
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase and Firebird
> > http://www.interbaseworkbench.com
> >
> >
> > --- In ib-support@y..., "Martijn Tonies" <martijn@b...> wrote:
> > > Hi,
> > >
> > > InterBase isn't lying to you - it's returning FLOATING POINT values.
> > >
> > > Floating point values aren't precise, never, not in any language -
> > if
> > > you want exact numerics, use NUMERIC(15, 2) or so as the datatype.
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> >
> > Martijn, you forgot to say "and FB/IB6 dialect 3 instead of IB5.6"
> > :) Since both Numeric and Decimal with precision greater than 9 are
> > stored as floating point types, real data will be stored accordingly
> > this underlying types and can cause some headache on usage in
> > expressions and aggregates gathering.
> >
> > Best regards, Alexander V.Nevsky.
> >
> >
> > 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/
> >
> >
>
>
>
> 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/
>
>
>