Skip to Content
0
Former Member
Jul 18, 2016 at 06:19 AM

transaction notification

33 Views

I Have here may transaction notification, how can i exempt from this rule a "cancel doctatus"

thanks

--Duplicate Lab ID Reference Not Allowed

if @object_type = '17' and (@transaction_type= 'A' or @transaction_type= 'U')

begin

declare @LabID as varchar(200)

select @LabID = U_Lab_ID from RDR1 where docentry =@list_of_cols_val_tab_del

if 1 != (select count(docentry) from RDR1 with(nolock) where U_Lab_ID = @LabID)

begin

select @error = -3

select @error_message = 'Duplicate Lab ID Reference Not Allowed!'

end