How to refresh a field on a form

[John Fligg]

As per the attached screen shot, I add invoice lines to the invoice. In the embed point GotFocusBack I calculate the Invoice totals by reading the relevant invoice lines, calculate discount etc.

The value returned is correct at that time.

However I cannot see how to refresh the Net, Tax And Gross fields on the form to show the new calculated values.

John

[attachment deleted by admin]

[Devan]

John,

Try this - in your NetWebForm procedure in Clarion, go to the BrowseLineItems (or whatever it is called) field which calls the Browse for the line items on the form.

Go to the 'Client-Side' tab.  In the 'Refresh Other Fields' list box, click 'Insert' and choose the 'Nett' field, and ensure 'Value' is ticked.  Do the same for the other two fields you want refreshed.

I've done this successfully on normal entry fields, but not tried it on a Browse field.  Hopefully when the browse changes, it will trigger the other three fields below to force update.

Let me know how it goes!

Cheers,
Devan

[John Fligg]

No sorry that does not work.

Looks like an examaple coming up for Bruce. Damn!

John

[John Fligg]

Bruce - sorry about the quick throwing together of this.

Attached test3.zip. The aim is to go to an Invoice FORM, add invoice lines from the browse and REFRESH the invoice total.

To do that go to Browse/Invoice/Add. Give it a sequential number and leave the total blank. Now click Insert below to add a new invoice line. BUT I cannot find out why but the relationship is not working. So just type the Invoice ID in manually.

Now add an amount and save. The invoice form is now refreshed and the invoice line is shown. In the INVOICE embed (GotFocusBack) I total the invoice lines. I have checked that and at this stage it is correct. The invoice total has been calculated.

All I now want to do is refresh the INVOICE window to show that total.

In my code I update INV:Total and SSV('INV:Total',LOC:Amount) in case one was not working.

BTW The examples do not store the amounts in the records and are calculated at runtime. I cannot do that and must have the amounts held in the invoice record itself.

Thanks

John

[attachment deleted by admin]

[Bruce]

you were so close, just lost your confidence at the last second.
just add one more line to your existing update code (in gotFocusBack routine)

do Refresh::Inv:Total

you calc'd it correctly, and updated the memory session variable correctly, but you need to then "reset" the field in the browser.
and that's done with the Refresh::fieldname routine.

[John Fligg]

Thanks Bruce. I knew it was easy.

Cheers.

John

[osquiabro]

this work for insert and update but not for delete..

[osquiabro]

somebody resolved the delete issue and refresh??