Hello!
I have a transaction group set up to executed once the status submit boolean is set to true. This all works correctly but the data is not being written to the DB. This is the stored procedure I have for the transaction gorup.
USE [Fake]
GO
/****** Object: StoredProcedure [dbo].[sp_SUBMIT_WO] Script Date: 7/13/2022 4:43:01 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
--ALTER PROCEDURE [dbo].[sp_SUBMIT_WO](
@WO_Status char,
@WorkOrder_ID varchar(25) OUTPUT,
@FinishTime DATETIME,
@Good_Part_Count int OUTPUT,
@Scrap_Part_Count int,
@Total_Part_Count int,
@Part_ID varchar(25) output,
@LoadedBit bit OUTPUT,
@InProgBit bit OUTPUT,
@SubmitBit bit OUTPUT
) AS
BEGIN
UPDATE Inventory2
SET
WO_Status = @WO_Status ,
Finish_Time = @FinishTime,
Good_Part_Count = @Good_Part_Count,
Scrap_Part_Count = @Scrap_Part_Count,
Total_Part_Count = @Total_Part_Count
WHERE WorkOrder_ID = @WorkOrder_ID
SELECT
@WorkOrder_ID ='BLANK',
@Good_Part_Count = 0,
@Part_ID = 'BLANK',
@LoadedBit = 0,
@InProgBit = 0,
@SubmitBit = 0
END
RETURN 1
I will paste a screenshot below to show what the transaction group consists of.
Any ideas why it would not be writing to the DB? I had to create two reference tags, one for Input and one for Output. Could this be the cause of the error?
This is from the profiler to show no data is being written to the DB.
Thank you!