Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> SQL Server to .net datatype error
 

Pages: 1
LLBLGen Pro Runtime Framework
SQL Server to .net datatype error
Page:1/1 

  Print all messages in this thread  
Poster Message
tprohas
User



Location:
Tucson, AZ
Joined on:
23-Mar-2004 00:00:43
Posted:
257 posts
# 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.
Aaron Prohaska
http://www.verdesoft.com/
 
Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8060 posts
# 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'ing (articles and code snippets) | linkedin | twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37405 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.