Buenas tardes.
alguien de ustedes sabe por que al generar un transaction para estos dos campos y al meterlos a un flujo de aprobación ya no funciona.
PRQ1.OcrCode
PRQ1.OcrCode2
IF @object_type = '1470000113' and @transaction_type in( 'A' )
BEGIN
DECLARE @Area nvarchar(20)
DECLARE @Departamento nvarchar(20)
DECLARE @CeCo nvarchar(20)
DECLARE @ContS int
SET @Area = (SELECT COUNT(T0.OcrCode2) FROM PRQ1 T0 INNER JOIN OPRQ T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.OcrCode2 <> ' ' AND T1.DocEntry = @list_of_cols_val_tab_del)
SET @Departamento = (SELECT COUNT(T0.OcrCode3) FROM PRQ1 T0 INNER JOIN OPRQ T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.OcrCode3 <> ' ' AND T1.DocEntry = @list_of_cols_val_tab_del)
SET @CeCo = (SELECT COUNT(T0.OcrCode) FROM PRQ1 T0 INNER JOIN OPRQ T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.OcrCode <> ' ' AND T1.DocEntry = @list_of_cols_val_tab_del)
SET @ContS = (SELECT COUNT(T0.LineNum) FROM PRQ1 T0 INNER JOIN OPRQ T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.DocEntry = @list_of_cols_val_tab_del)
IF (@ContS <> @Area) or (@ContS<>@Departamento) or (@ContS<>@CeCo)
BEGIN
SELECT @error = 67
SELECT @error_message = 'Existe alguna línea del documento sin CeCos'
END
END
saludos, gracias.