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
