Pervasive SQL 8.0
-
Hi there, anyone using Pervasive SQL 8.0?? I have an issue with transactions using C# on Pervasive SQL 8.0. The transaction does not wait when there is a lock (another transaction operating) on the table. It just throws an exception. Thanks for helping
-
Hi there, anyone using Pervasive SQL 8.0?? I have an issue with transactions using C# on Pervasive SQL 8.0. The transaction does not wait when there is a lock (another transaction operating) on the table. It just throws an exception. Thanks for helping
What Exception it throws?
Regards, Satips.:rose:
-
What Exception it throws?
Regards, Satips.:rose:
A btrieve error 85 is thrown, which means the file is locked. Right now, my solution to this problem conbsists of looping through a try-catch block and keep trying until the file is unlocked. I was just wondering whether there is a more elegant solution to that.. bool bSuccess = false; int nCount = 0; while (!bSuccess && nCount < 30) { try { da.Update(dsControl, "Control"); // this throws the exception if // there is a lock on Control bSuccess = true; } catch (Exception ex) { nCount++; } } I suspect something wrong with Pervasive SQL 8.0.. :$