采购订单：单价必须填写

五六零网校小于 1 分钟

示例代码

--采购订单：单价必须填写
 IF @object_type='22'
 begin
 if @transaction_type='A' OR @transaction_type = 'U'
 begin
 if exists(
 SELECT T1.[Price] FROM OPOR T0  INNER JOIN POR1 T1
 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[Price]  is null or  T1.[Price] <=  0 and  T1.[DocEntry]=@list_of_cols_val_tab_del
 )
 begin
 select @error=1
 select @error_message='订单单价必须填写'
 
 end
 end
 end