Skip to Content
0
May 18, 2016 at 08:03 PM

Error en bloqueo

17 Views

Buenas tardes a todos

Estoy realizando un bloqueo de dos campos de usuarios declarados como Alfanumérico (2), pero cuando ejecuto el proceso me manda error

IF @object_type = '4' AND @transaction_type IN ('A', 'U')

BEGIN

IF EXISTS(SELECT T0.U_Max_M FROM OITM T0 WHERE T0.Itemcode = @list_of_cols_val_tab_del AND (T0.U_Max_M IS NULL OR T0.U_Max_M =''))

SET @error=113

IF EXISTS(SELECT T0.U_Min_M FROM OITM T0 WHERE T0.Itemcode = @list_of_cols_val_tab_del AND (T0.U_Min_M IS NULL OR T0.U_Min_M =''))

SET @error=114

SET @error_message=

CASE @error

WHEN 113 THEN 'Completar Maximo en Meses'

WHEN 114 THEN 'Completar Minimo en Meses'

END

END

Attachments

error.jpg (10.7 kB)