Announcements
How to patch automatically the changed/refreshed value from sql server.I have Target (manually entered in App),Actual( comes from sql server) and difference column i.e Actual - Target.I want to patch the difference value back to sql stable but the issue is Actuals value is very dynamic and changes every minute or so,it patches the difference first time correctly but when the value changes on the screen it does not patch backs the refreshed value. I have used timer to refresh every 30 seconds the Actual table.TIY.
@nordic ,
OnChange of your Actuals value, You can store the actuals value into variable and then compare the actual value everytime with the actual value that you have stored in the variable, and if those two values are different, the patch it to SQL.
@Bilakanti Thanks a lot for the idea ,seems it will work i will give a try.One more side query is it possible to patch as soon as the change on the screen is visible? or we have to rely on timer end patch.Thanks again.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 352 Super User 2026 Season 2
M Bilal Khan 323
Mohsin Ali 226
