>hello all,
>I am experiencing this abnormal behavior in my grid.
>Unit price * qty <> total (sometimes.)
>when i enter unit price it most iof the time calaculates a zero total even when
>qty non zero.
>e.g
>interative change. of unit price
>thisform.grid1.column7.text1.value = round((this.value * thisform.grid1.column6.text1.value),2)
>thisform.calctotvalue
>
>grid is bound to cursor in code.
>is there a trick somewhere.
>I'll will greatly appreciate some help since this has been bothering me for sometime now.
>Thanks in advance.
Hi Sammy,
I believe, I answered the similar question once. Instead of using thisform.grid1.column6.text1.value try:
replace Total with round(Qty*Price,2), IOW, use the cursor fields instead of grid controls.
If it's not broken, fix it until it is.
My Blog