Subject | Re: [ib-support] Re: Strange roundings in IB-5.6 |
---|---|
Author | Bengt Skogvall |
Post date | 2002-04-03T12:08:41Z |
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
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/
>
>
>