Devart Forums

Hi,

I use NonBlocking option (true) to prevent blocking update by another user.

After my timeout (WaitExecuting) i call BreakExec. The problem is when i want to free my objet. The instruction wait for until the other who lock the record commit. Can you tell me what can i do?

My example :


pOraSQL->NonBlocking = true;
pOraSQL->Execute();

pOraSQL->WaitExecuting(5);

if(pOraSQL->Executing())
{
pOraSQL->BreakExec();
delete pOraSQL; //lock until transaction no committed by the other user.
throw Exception("LOCK");
}

The problem appear only when i update a record witch include a blob field (with a not null value)

Support team said me :

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.