(Back to Z-TS Transaction Notification SQL Scripts Posted to Wiki Listing -Z-TS Transaction Notification SQL Scripts Posted to Wiki )
TYPE: Monthly Special
AUTHOR NAME: Neetu Dhami
PURPOSE AND BACKGROUND: This SQL was created in 2007A SP01 PL08. It can be used to prevent users from entering duplicate barcodes for Items and can be modifed as per the customer requirement.This script can be pasted in transaction notification procedure.
Copy and Paste this SQL:
--Z-TS Script to prevent enetring duplicate barcodes for Items Ver 1 ND 02 June,2011
--DESCRIPTION: Transaction notification SQL script can be used to prevent users from entering duplicate barcodes for Items and can be modified as required.
--Version 1 Neetu Dhami 02 June, 2011
If @object_type = '4' and @transaction_type in ( 'A','U')
declare @BarCode nvarchar(16)
set @BarCode=(Select isnull(T0.CodeBars,'') From OITM T0 Where T0.ItemCode = @list_of_cols_val_tab_del)
If @BarCode!='' and
exists (Select T0.CodeBars From OITM T0 Where T0.CodeBars = @BarCode and T0.ItemCode ! = @list_of_cols_val_tab_del)
Select @error =12, @error_message = 'Bar Code Already exists(Duplicate Barcode)!!'