Contracts ?

Aug 2, 2006

Hi There

I have noticed that one cannot alter a contract, there is no alter contract syntax.

I understand the reason is because one can break applications by altering messages in contracts used to build apps.

However now it seems that everytime i create a new message type i have to create a new contract which in turn i have turn alter a service to use it. I cannot drop and re-create contracts because they are bound by services.

So basically what i am saying is that it is really a mission to add new messages types in a complex SB application (create new message+create new contract+alter service), is this just the way it is or what am i missing here ?

Thanx

View 3 Replies


ADVERTISEMENT

Transact SQL :: Get A List Of All Contracts Equal Or After To Their Maximum Contract

Jul 7, 2015

I have two tables and a CTE table.

-Shop : list of all shops with an ID_SHOP
-Contract : list of all contract with a FK to the shop FK_SHOP. A shop can have multiple contracts

I have a cte where I calculate for each FK_SHOP the maximum contract start date. I now want to join my shop table with the contract table but only for the contracts >= their maximum contract start date.

WITH cteContracts AS
(
SELECT
FK_SHOP
,ID_CONTRACT
,MAX(cont.DTT_START_DATE) DT_STARTDATE

[Code] ....

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved