dmccabe Posted April 1, 2008 Share Posted April 1, 2008 I have 4 fields in a database which are set as type "DECIMAL(4,2)" These are to hold montery values eg: 99.00 and distance in miles eg: 59.5 This works until I put in a 3 or 4 digit number before the decimal place eg: 1000.26 At which point I get this error: "Error: Out of range value adjusted for column 'delhours' at row 1" Anyone give me any clues why? Quote Link to comment Share on other sites More sharing options...
paul2463 Posted April 1, 2008 Share Posted April 1, 2008 yes I can because the decimal number 1000.26 is actually a "DECIMAL(6,2)" the decimal format requires two arguments, the first is the maximum number of total digits allowed and the second is the maximum number of digits after the decimal point hope that helps Quote Link to comment Share on other sites More sharing options...
dmccabe Posted April 1, 2008 Author Share Posted April 1, 2008 Superb, thanks Paul! :0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.