CREATE PROCEDURE
Command Run_put_edit_
— Pan Shin
@p1 int, @p2 int, @p3 int
AS
- -print 'CommandRun_put_edit_'
declare
@No varchar(128),
@Name varchar(128),
@Pr Key varchar(255),
@str varchar(128),
@special int
— Docs fields
select @Name=String Value from Detailed where u=@@spid and UDN=@p1 and Value Id='Name'
select @No=String Value from Detailed where u=@@spid and UDN=@p1 and Value Id='No'
select @Pr Key=String Value from Detailed where u=@@spid and UDN=@p1 and Value Id='PrKey'
- - Все обновления сохраняем
declare @Pr Key_save varchar(255)
update Docs set Name=@Name, No=@No where UDN=@p1
update TCT_CommandRun set Pr Key=@Pr Key where UDN=@p1
GO
