executescalar in middle (be part) of transaction

Author	Message
Fabian R Silva, -	Fabian R Silva, - posted 12 Years Ago Topic Details Share Topic
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)... Tags executescalar transaction Edited 12 Years Ago by Fabian R Silva, -
	Reply Like 1

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Fabian R Silva, - - 12 Years Ago

Hi Fabian, Please post the code for the GetNextNumber method as...

Edhy Rijo - 12 Years Ago

basically it receive a data from the bo to be saved (idTalonario) and...

Fabian R Silva, - - 12 Years Ago

The GetHastaNumeroProximo method should be in the ComprobantesBO...

Edhy Rijo - 12 Years Ago

Fabian R Silva, - - 12 Years Ago

I see that I was wrong on what I tried to accomplish, I will explain...

Fabian R Silva, - - 12 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login