Subject | Problem with multiple users editing |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-10-15T10:03:11Z |
Looks like I don't get this multiple users editing same record stuff.
My transasction is tiCommited, AutoCommit=true, lockwait=false.
In BeforeEdit I call StartTransaction().
But still, when I run two instances of my program, nothing stopps me from
editing same record in both programs. I start editing in 1, then start
editing in 2, post 1,post 2 - and the winner is 2.
Is the only solution to make EditSQL check all fields for old values? It
would be better to warn 2. user in the beginning, that this record is
already in edit mode.
Riho-Rene Ellermaa
senior programmer
Hansabank
My transasction is tiCommited, AutoCommit=true, lockwait=false.
In BeforeEdit I call StartTransaction().
But still, when I run two instances of my program, nothing stopps me from
editing same record in both programs. I start editing in 1, then start
editing in 2, post 1,post 2 - and the winner is 2.
Is the only solution to make EditSQL check all fields for old values? It
would be better to warn 2. user in the beginning, that this record is
already in edit mode.
Riho-Rene Ellermaa
senior programmer
Hansabank