NexusSmallErp : CommandRunoffdel

CREATE PROCEDURE Command Run_off_del_
— Pan Shin
@p1 int, @p2 int, @p3 int
AS

if (select status from TCT_CommandRun where UDN=@p1) <> 0
begin
raiserror('Коррекция записи указателя отчета блокирована. В операции отказано!', 11, 11)
return 1
end

delete from TCT_CommandRun where UDN=@p1
delete from Docs where UDN=@p1
delete from Ext Columns where UDN=@p1
GO