Hi, I had used Table Box in my form to create a worksheet data entry screen (like Excel). When the user entre values in a particular row and column, i am recalculating another rows values. But in the screen i can see the current row values alone getting changed. The other row which i had recalculated is not getting refreshed. Eg. Row 1 column 3 user enters the value and Row 7 Column 3 i am totalling the column 3 values of row 1 to row 5. The screen (Table Box) does not refresh on the row 7 with the new calculated value. Only if i move the cursor over row 7 the values are getting refreshed. Is there any function avaliable to refresh Table Box dynamically with the latest values of table. Can somebody help me… Thanks & Regards A.RAMAKUMAR
Did you try CURRFORM.UPDATE? btw, If you are using a matric form, this problem will not easy to fix.
Thanks Emiel Romein. I had used CURRFORM.UPDATE, then the table box gets refreshed. Thanks once again.
I also have a problem like you. I recalculate my quantity with a boolean variable. Everything works fine i set the variable true and my quantity changes but the line amount didn’t. It also doesn’t change if i run over the new quantity with enter, it only changes when i use “F2” to reenter the quantity. How can I fix this silly problem. I already tried CURRFORM.UPDATE but nothing apears.
quote:
Originally posted by PeeTsche
I also have a problem like you. I recalculate my quantity with a boolean variable. Everything works fine i set the variable true and my quantity changes but the line amount didn’t. It also doesn’t change if i run over the new quantity with enter, it only changes when i use “F2” to reenter the quantity. How can I fix this silly problem. I already tried CURRFORM.UPDATE but nothing apears.
Can you descripe your problem more detailed? Is Quantity field in the same line as Amount? Is it table control?
I work with the purchase line table. With a boolean variable in the same line as the quantity i set my quantity to a fix number i calculated before. So the problem is when i validate the boolen the quantity in the line change that’s what i want but the line amount in this line doesn’t update with the quantity it’s still calculated with the the old quantity before setting the boolean true. So what i want is when i set the boolean in the line true, the quantity must change and the line amount must be recalculate with the new quantity. I hope now you can imagine what i want 
Hi
quote:
Originally posted by PeeTsche
… So what i want is when i set the boolean in the line true, the quantity must change and the line amount must be recalculate with the new quantity. …
Just look in the OnValidate- Trigger of Quantity. You have to call this code. But I don’t know how[:(]. There was a function in BLUE called ‘CallFieldCode’. I didn’t found something similar in the newer versions. bye André
You can call OnValidate trigger using VALIDATE function. Rec.VALIDATE(“Field Name”);
quote:
Originally posted by Arthur
You can call OnValidate trigger using VALIDATE function. Rec.VALIDATE(“Field Name”);
Thank You! Only to make it clear: Rec.VALIDATE(Field) is similar to dbCallFieldCode(Field) (in Blue)??? bye André
Yes, it is.
Thank you that’s it. Rec.VALIDATE(“Quantity”); is the answer - now i can go home [:D]