Thank you, that’s a great help!
What I need is closer to Example 2 of synchronous data.
I’ve looked at Ajax docs and other examples on this forum such as: https://discourse.hkvstore.com/t/how-to-call-stored-procedure-v2020/1221/1 but could not figure out the correct format required for the call.
Something like this:
var data = { CommandType: ‘StoredProcedure’, CommandText: ‘writelog_bare’ };
var res = ew.ajax(data);
where ‘writelog_bare’ is the name of a test stored procedure that takes no inputs but only writes to a log table.
But res comes as ‘undefined’ after the call.
Could you please guide me on the format for the Ajax call and how to pass variables?