SQL Server to .net datatype error

Posts   
 
    
tprohas
User
Posts: 257
Joined: 23-Mar-2004
# Posted on: 14-Mar-2009 06:12:28   

LLBLGen Pro 2.5 v2.0.50727 ASP.NET 2.0 SQL Server 2008

I'm getting the following error from a field where I have set the sql server data as decimal (4,2). Can anyone tell me why the negative doesn't fit? I would suspect that if this was a positive value it would work. Should I make the the datatype decimal (5,2)?

The precision of value '-18.81' is larger than the precision of the field: '4' and will cause an overflow in the database.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 14-Mar-2009 09:48:46   

This is due to the Build-in field validation logic. You can disable it or set a correction action for the scale.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 14-Mar-2009 16:00:15   

Also please check the latest v2.5 runtime lib builds (you posted the .net version , not the buildnr). There were some issues with the validation checking in earlier builds.

Frans Bouma | Lead developer LLBLGen Pro