on 11-01-2016 7:36 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hola Alessandro gracias por la ayuda quedo perfecto.
Saludos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.