|Subject||RE: [IBO] Lock Conflict Problem|
> -----Original Message-----Lester, I think you meant the trigger is not fired until the record is
> From: Lester Caine
> Again, the trick is to keep to a minimum the information that is
> modified. The triggers are not fired until a commit is made, so
> everything should be stable, and nothing should lock because
> the commit
> happens quickly. The problem comes when you start trying to scan
> multiple records which other users may also be accessing ...
inserted or updated, and if AutoCommit is on then the commit will happen as soon
as the insert/update succeeds.
COMMUNICARE DEVELOPMENT TEAM
Communicare Systems Pty Ltd
08 9332 2433
041 9906 150
08 9310 1516 (fax)