Hello Group,
�
Thanks for letting me join. I have one customer for my income and am
semi-retired. I am a long time user / sys admin of Firebird 2.7.1 and I need
to migrate this version from a Windows Server 2003 OS to a newer Windows Server
2016. It is on a VMware server and has been for
Maybe between 8 and 15 decimals, not more.
Em qua., 26 de fev. de 2020 às 16:10, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escreveu:
> 26.02.2020 19:41, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> > I need to store long decimals numbers maybe more than 15
26.02.2020 19:41, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I need to store long decimals numbers maybe more than 15 decimals, is it
> possible without
> store as string?
If your task requires such number you should consider using of Firebird 4 or
Oracle.
--
WBR, SD.
When I started my test, I turn off my app.
And do update(and select) using only ISQL tool (IBExpert) and dbweaver.
in both I had to configure select to show float using mask (0.##..), so
the number can be different that I show you, but always eat last numbers.
I need to store long decimals
On 2020-02-26 19:07, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> Hi All,
>
> I do this update:
> UPDATE CV SET
> perc_lucro=42.503064336972848
> WHERE (id_cv=57528)
>
> Then I do a select and 'perc_lucro' was change to 42,5030643369728
> after updated, two last numbers
Hi All,
I do this update:
UPDATE CV SET
perc_lucro=42.503064336972848
WHERE (id_cv=57528)
Then I do a select and 'perc_lucro' was change to 42,5030643369728 after
updated, two last numbers disappear.
Why?
perc_lucro is double precision type.
FB 3.0.5 32bits, Windows 64.
On 2020-02-26 06:22, Matthias Winkler spmm...@gmail.com
[firebird-support] wrote:
> Hello Firebird-Group,
>
> With our device we recalculate statistics ALWAYS when booting up the
> system. Now the DB grows bigger this can now take more than 10 minutes
> and delays
> the time until we can really
HiTo take decision you first must know what statistics are for server e.g.
Firebird. Statistics contain info how selective is some index. If it is PK you
know that every entry have only one record. For UK you have same but you can
have multiple nulls. For other indexes you can have for one
