executescalar in middle (be part) of transaction


Author
Message
Fabian R Silva, -
Fabian R Silva, -
Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)Advanced StrataFrame User (691 reputation)
Group: StrataFrame Users
Posts: 153, Visits: 1.2K
I need to execute a "executescalar" on a transaction to get the last invoice number again (if someone get the number that the actual invoice have... change it before save on this transaction)

I have:
...(try)...
BusinessLayer.TransactionBegin("invoiceTr", IsolationLevel.ReadCommitted);

var nextNumber = invBO.GetNextNumber(invBO.IdTalonario, DataSourceKey); // <--- THIS METHOD call a  EXECUTESCALAR VALUE.... freezes and timeout after some seconds...
invBO.Numero = invBO.HastaNumero = nextNumber;

saveUndoResult = invBO.Save(true);
...
...
...(rollback/commit)...
Edited 14 Years Ago by Fabian R Silva, -
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Fabian R Silva, - - 14 Years Ago
Edhy Rijo - 14 Years Ago
Fabian R Silva, - - 14 Years Ago
Edhy Rijo - 14 Years Ago
                     -
Fabian R Silva, - - 14 Years Ago
                         I see that I was wrong on what I tried to accomplish, I will explain...
Fabian R Silva, - - 14 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search