I tried adding MultipleActiveResultSets=True to the connection string for .NET - still I get the same error back
I have also switch my variant to WinC and using SQLCLIENT Driver - my code behaves as expected - allocates the next Sequence from the Surrogate table (locks the Recordset) - if the Insert (or check row) fails then the action is rolled back and the surrogate table is NOT updated - as i was hoping to acheive
(to test this I renamed one of the columns on the table to force the insert to fail ) after building and ensuring that the function worked as expected -
this is a Basic Edit Detail
No other code was added other than below
- the default 'InsertRow' function was FNC Commit Parent
in the 'End Insert Row' edit point -
If Environment<*Returning status> == <*Returning status.*Successful>
Commit
Else
Rollback
Set Environment<*Returning status> = <*View status.*Error>