Hello Experts,
Is it possible to call a stored procedure from web designer as part of a format clause?
I have a backend SQL function which returns an MD5 hash of a value, and I need to call this function in the format clause in the front end, something like this:
format("mycolumn='{0}', exec CCC_Myfunc(value))
I can do this by using a script, but wanted to know if its possible for WD to directly call the backend SP and get the result rather than using a script as an intermediate (for perfoamcne reasons)
Thanks
Kin