Show Information and Confirmation Message before excute an update query

Hello all,

I created a program to update certain data. In event onValidate before executing the query I want to display the data which is stored in database and also a confirmation message if the user still want to change or not.
If the user presses the ‘Yes’ button, then the update query can be executed. If the user presses the ‘No’ button, then the update query is not executed.

How to do this with Scriptcase?

I already try sc_confirm but can’t show the variable’s value.

Re: Show Information and Confirmation Message before excute an update query

I created my own buttons on the form and a control application (like the login-app) where I redirect to (I use modal). Depending on the user’s action I print, save, … or do nothing and return to the form.
The problem with the sc-macro is, that you don’t get a return value, so you have to create something by your own.

Re: Show Information and Confirmation Message before excute an update query

Can you provide the source code for your solution jsbinca?

The sc_macro works only in ajax event but not in the onValidate event. Hence, your solution would be the best option.