First time trying to write back to the database using a web service and everything is working - mostly.
When I use a trigger cell to call a stored procedure that does an update it works as expected.
However, when I modify the sp to use an input parameter, then map that parameter to the same cell I was using before then I get the 2032 error. Since step one works I’m assuming it’s not a permission or crossdomain issue.
I’m guessing it’s a syntax error in the query itself, but I’ve tried adding quotes, spaces, etc. to the values but no luck. I have installed Fiddler hoping to get a look at the actual query being passed but so far I haven’t figured out how to do that.
Is it possible to view the query, or does anyone have other ideas on how to troubleshoot this? Since it’s so close to working the way I want then I can’t imagine it’s a complicated fix. Thanks in advance.
dukeslater (BOB member since 2007-02-15)