Re: [firebird-support] double precision remove last 2 numbers

2020-02-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-02-26 19:41, hamacker sirhamac...@gmail.com [firebird-support] wrote: > 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

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread hamacker sirhamac...@gmail.com [firebird-support]
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

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread hamacker sirhamac...@gmail.com [firebird-support]
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

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support] double precision remove last 2 numbers

2020-02-26 Thread hamacker sirhamac...@gmail.com [firebird-support]
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.