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.
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.
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.