How large of an Integer can an Integer field hold? Is it a smallint, int, or bigint?
Like
Maximum value integer field can hold is 2147483647 and you can test in on your side as well - the system won't allow you saving numbers greater than 2147483647.
To add to what Oscar said, the SQL database type is int, but the restriction is also due to the .NET datatype in the entity, which is an Int32 (an Int32 has a +/- 2147483647 max size) https://docs.microsoft.com/en-us/dotnet/api/system.int32?view=netframew…
Ryan
Add comment
Oscar Dylan, Ryan Farley,
Thanks. I've changed my field to String since the values are out of range.
is there any way to accept bigger values? in my case I'm working a project to manage public works, such as roads, dams, stadiums, etc., and the amounts are very large.
Also I saw I can introduce larger decimal values, this have no logic why I can introduce 52.437.560.581,00 and not 52.437.560.581? In the case of customer they didn't use decimals, price of the public works are Integer
Julio.Falcon_Nodos,
this is .Net Framework restriction and Creatio can't really do anything about it. They could only create a long datatype for big integers