Subject | |
---|---|
Author | apatri@inwind.it |
Post date | 2001-11-23T13:55:13Z |
Hi All.
I have a problem.
I have a field declared numeric( 9,4 ) " WORKING_HOURS" in which I
set the amount of hours necessary to build a single unit.eg: 0,20
minutes or 1,20 hours.
Now I have a field Quantity declared NUMERIC( 9,4 ) in which I put
the items of the product to be build.
Multiply WORKING_HOURS * QUANTITY show me some incredible wrong
results.
cast(WORKING_HOURS as time ) * QUANTITY <--- don't work.
What is the line of code that works?
Someone wants help me?
Thanks for Your patience.
Thanks
Tony
Now if I do
I have a problem.
I have a field declared numeric( 9,4 ) " WORKING_HOURS" in which I
set the amount of hours necessary to build a single unit.eg: 0,20
minutes or 1,20 hours.
Now I have a field Quantity declared NUMERIC( 9,4 ) in which I put
the items of the product to be build.
Multiply WORKING_HOURS * QUANTITY show me some incredible wrong
results.
cast(WORKING_HOURS as time ) * QUANTITY <--- don't work.
What is the line of code that works?
Someone wants help me?
Thanks for Your patience.
Thanks
Tony
Now if I do