Problems with saving records ....

[jlmaxwell]

I've got a multi-user database application using DOA in Delphi 4, accessing oracle8. I'm using TOracleDatasets and TOracleSession.
The problem is some of my user have complained the at times, there not able to save records being entered / told the record is locked by another user.
Has anyone got any ideas which could help .... T.I.A.
Max....

 

[Marco Kalter]

If the TOracleDataSet complains that a record is locked by another user, then I can only assume that there is another database session that has updated or locked (select ... for update) this record.

This can of course be a perfectly normal situation in a multi-user application, but it can also be that an application is generating locks without releasing them (through a commit or rollback).

------------------
Marco Kalter
Allround Automations