AnsweredAssumed Answered

Using Commit/rollback with SQL server - .NET and plex patterns -

Question asked by WayneMorgan on Jul 27, 2015
Latest reply on Aug 17, 2015 by WayneMorgan

Trying to put a simple Commit/transaction set in the 'Surrogate Entity' process -  .NET C# SQL Server 2008 

 

using a simple 'Edit' pattern - I want to ensure that the surrogate on the surrogate system table only gets allocated IF the insert was succesfull

 

so following the plex help I should be able to specify the  'Insert row' (that includes the call to the 'get Next surrogate' function &  update row of that table) as a fnc Commit SYS Parent - and then issue the Commit/rollback after the Insert statement in the

 

 

Anyone had success at this or what am I missing here?

Outcomes