numeric переполняется при вычислениях. Пример:

select cast(1 as numeric(15,2))*cast(1 as numeric(15,2))*cast(1 as 
numeric(15,2))
*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))
*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))
*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))*cast(1 as numeric(15,2))
from rdb$database

С уважением, Самохвалов Григорий




--~--~---------~--~----~------------~-------~--~----~
-~----------~----~----~----~------~----~------~--~---

Ответить