TREAT

Overview:

This article provides the Status change queries for online forms 

-- Find the online form ID

SELECT OnlineFormID

  FROM TR_OnlineForm

WHERE ReferenceID = <>;

-- Update the status back to Pending, and set the last carousel step executed back to NULL

BEGIN TRAN

UPDATE TR_OnlineForm

   SET Status = 1, /* Pending */

       LastSuccessfulStep = NULL

WHERE OnlineFormID = <>;

-- COMMIT

begin tran

update TR_OnlineFormClient set TreatClientID='-1' where OnlineFormID =16902; 

rollback tran