Код

	|declare @SelectedId char(9)
	|declare @SelectedDef int
	|declare @SelectedSign char(3)
	|declare @count int
	|set @SelectedId=?
	|set @SelectedDef=?
	|set @SelectedSign=?
	|update _1sjourn set verstamp=(select verstamp from _1sjourn where iddocdef=@SelectedDef and iddoc=@SelectedId)+1
	|where iddocdef=@SelectedDef and iddoc=@SelectedId
	| set @count= (select count(*) from _1supdts where typeid=@SelectedDef and objid=@SelectedId and dbsign=@SelectedSign)
	|if @Count=0
	|begin insert into _1supdts values ( @SelectedSign, @SelectedDef, @SelectedId, ' ', ' ')
	|end
	|else
	|begin
	|update _1supdts set dwnldid= '' where Typeid=@SelectedDef and Objid=@SelectedId and DBSign=@SelectedSign
	|end";