AM desciperit unde e buba procedura se executa intradevar dar o ia pe ramura else adik message_type nu e insertie.SI pe receiver in tabela care trebuie s-o reeplice am inregistarea cu 'nu e bine' in loc de ce am inserat pe sender.
if
(@msgtype='insertie')
insert
into tbl_boy select * from boys(@msg)
-- Insert statements for procedure here
else
insert
into tbl_boy values('nu e bine',-1,-1)
end conversation @conversation
END
O sa postez si trigerrul de insert pe sender in care initiez dialogul si trimit mesajul de inserare poate ma poti lamuri de ce @msgtype nu are valoarea insertie cand mesajul ajunge pe receptor
ALTER
TRIGGER [dbo].[sendinserturi]
ON [dbo].[tbl_boy]
AFTER INSERT
AS
BEGIN
declare
@dialoghandle uniqueidentifier
declare
@inserturi xml
set
@inserturi=(select * from inserted for xml raw('boy'),root('boys'))
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
begin
dialog conversation @dialoghandle from service sender to service 'receptor' on contract repl1 WITH ENCRYPTION = OFF
-- Insert statements for trigger here
;
send on conversation @dialoghandle message type insertie(@inserturi)
END
Multumesc dinnou
Secolul XXI ori va fi religios ori nu va fi deloc