------物料主数据计量单位的控制
IF (@object_type =‘-3 @IV_CLASS3‘ AND @transaction_type IN ( ‘A‘,‘U‘))
BEGIN
IF EXISTS (SELECT TOP 1 1 FROM [@IV_CLASS3] T0
WHERE T0.Code = @list_of_cols_val_tab_del AND (T0.U_Batch=N‘Y‘ AND T0.U_Serialnum= N‘Y‘))
BEGIN
SET @error = -40102
SET @error_message = N‘ERROR：批次和序列号不能同时选择！‘
RETURN
END
END 无对象控制
原文：http://blog.51cto.com/johnny/2059569
