I have a problem on stored procedure
this script is works for me to prevent added of SO.
How can make this work if i want to added S.O as Draft --- Please See Image Below for your reference
Thank you in Advance for your HELP..
IF @object_type = '17' AND @transaction_type IN ('A', 'U')
IF exists (Select U_CreditLimit_Exceed from [dbo].[ORDR] T0 where T0.U_CreditLimit_Exceed < 0
AND T0.U_triggered_code = true
SELECT @error = -1,
@error_message = 'To Proceed Please Change U_triggered_code to blank'