on 09-05-2016 6:25 PM
compa;eros quisiera que me ayudaran a bloquear el uso de otra bodega que no sea la 01 en la lista de materiales de produccion.
Prueba asi -> NO PODRAN CREAR O ACTUALIZAR:
if @transaction_type in ('A','U') and @object_type = '66'
BEGIN
declare @lineas varchar(2)
set @lineas = (Select Count('A') from ITT1 T0 where T0.Father = @list_of_cols_val_tab_del and T0.Warehouse <>01)
if @lineas > 0
begin
Select @error = 1, @error_message = 'No se permiete otro ALMACEN distinto a 01'
end
end
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
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.