Skip to Content
avatar image
Former Member

Bloqueo pormedio del Transaction

Jovenes necesito realizar un bloqueo en orden de compra, cuando sea por servicio la descripción del detalle no esté en blanco .

Agradeciendo su ayuda y tiempo

Saludos

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 19, 2016 at 12:16 AM

    Hola Carlos, intenta así:

    IF @transaction_type IN ('A') AND @object_type = '22'
    BEGIN if exists (Select T0.DSCRIPTION from dbo.POR1 T0 INNER JOIN OPOR T1 ON T0.DOCENTRY=T1.DOCENTRY where isnull(T0.DSCRIPTION,'')='' AND T1.DOCTYPE='s' AND T0.DocEntry = @list_of_cols_val_tab_del )
    begin
    SELECT @error = 1, @error_message = 'No se permiten descripciones en blanco'
    end
    End

    Saludos.

    Alessandro.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 10:07 PM

    Hola Alessandro gracias por la ayuda quedo perfecto.

    Saludos

    Add comment
    10|10000 characters needed characters exceeded