Announcement

Collapse
No announcement yet.

Refresh form data after Update

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refresh form data after Update

    In my form, I display ordinary user editable VARCHAR() type fields, and also some integer fields that are changed by triggers in the DB (These are set to "Read Only" so the user can see them, but not change them. I manually change the data in the user editable fields, then click "Save". After I click "Save", the data I changed is sent to the DB and committed, and all is working ok. However, I need to have the "trigger changed" field values show up in the record in the form, so that the user can see the new values of the "trigger changed" fields. This would be easily accomplished if I could some how do an automatic refresh of just the one record that I changed. I need: "AfterUpdate.... RefreshThisRecord" or something like that. Can anyone tell me how to accomplish this? ( I need the solution to work in both single record forms and Editable Grid forms. Thanks.

  • #2
    Did you ever found a solution for this? I have the same...thanks Bert

    Comment


    • #3
      Originally posted by ctmservice View Post
      Did you ever found a solution for this? I have the same...thanks Bert
      Ugly workaround is sc_redir macro. But I'm sure there's a better way.

      Comment


      • #4
        What might work is to set the form in a state that it will not automatically add an new (empty) rec after insert. Then you might be able by using an event to set the readonly thing. But I useually go for the sc_redir. I don't see this as an ugly work-around.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment

        Working...
        X