Hi All,
I’m having a bit of a problem with updating a custom table from the web.
I’m trying to use TR_LOCAL_PROCEDURE to update our custom Data Protection Preferences, and while I can get it to return the current/existing DPA preferences for a customer (with LWP_GET_PRIVACY_ACT), anytime we try to add new DPA (with LWP_ADD_PRIVACY_ACT) or update the existing DPA for a customer (with LWP_UPDATE_PRIVACY_ACT); it just replaces all values with NULL (which, helpfully - I can then return with LWP_GET_PRIVACY_ACT!).
If I run these procedures in SSMS (with valid session keys, etc) then the updates work as (I presume!) they should.
Any ideas what I could be missing? It’s really becoming quite the headscratcher!
(Or, should I be using the UpdateLocalData API call to do this? I’ve had a brief fiddle with this one too and wasn’t getting much joy there either!)
Thanks,
Paul.