I have form that loads some excel data into my MS SQL database, and when the data is loaded, it triggers my workflow to use the 'execute' SmartObject from the MS SQL stored procedure. The stored procedure has a merge statement that does something, followed by a delete and finally an update (in that order).
The issue:
When the workflow executes, the merge and update statements run perfectly fine, but delete statement does nothing. My guess is it is not being executed. The delete statement is a simple:
DELETE FROM dbo.table
So I tried using
TRUNCATE TABLE dbo.table
thinking is was an issue with the DELETE statement. Nope, still does not change anything. I execute the stored procedure in MS SQL Server and it runs just fine. Anyone know what the issue is?
