February 28, 2007 at 8:02 am
Howdy!
I am working on a payroll type application and have run into a snag.
If a person doesn't take a full 30 minute lunch, for example, from 12:00 to 12:20, we have to subtract 0.10 from the total.
I am using a field, duration, with decimal (18,2) data type. I am finding that it will hold a negative value 1 or greater, but not a value less than 1, like -0.10.
Is there a work around for this?
Many thanks for all the assistance!
Shelley
February 28, 2007 at 8:16 am
Shelley,
it works for me. Could you post the ddl and your insert procedures. Do you get an error? Which service pack level do you have?
Markus
[font="Verdana"]Markus Bohse[/font]
February 28, 2007 at 8:40 am
Hello Markus!
I found that I have a trigger that is preventing me from inserting the negative correctly. (DUH!)
Thank you for the quick response!
Shelley
February 28, 2007 at 8:59 am
and, the trigger did not have the duration defined as (18,2) so it was not seeing the fractional part.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply