Board index » delphi » How to know when a register is being modified?

2004-07-07 09:07:55 PM
delphi155
Hello,
I need to know when a register is being modified for another user.
Exemple:
I have two clients and one server with the DataBase. The Client1 initiates a
alteration in the record 10. When the Client2 to try to modify the record
10, the system must to inform that the record 10 is being modified.
Somebody know how to make this?
Thanks.
Dexter
 

Depends on the database you are using, the way you are accessing the
database and the field-level requirements. Quite honestly, if you are using
a transactional database such as SQL Server, Oracle etc. then this should
not be a problem.
What are you using, and can you be more specific about what specific need
you are trying to address? The typical scenario where this is an issue is
in something like a bank ATM transaction where the husband is in Las Vegas
trying to extract $5,000 for the tables and the wife is home trying to
extract $5,000 for her divorce attorney.
If both of them execute the command at the same time then who wins?
The answer is that it is up to the database to declare a winner and to then
deny the other transaction.
More info is required.
--
Mark A. Deal
Document & Data Solutions, LLC
www.docsol.com
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant
 

Pretty good analogy,,, we know who wins that one everytime though ...it
{*word*75}imistic locking ....
 

Del Murray writes:
--
jc
Remove the -not from email
 

Personally, I found that to be pretty funny!
--
Mark A. Deal
Document & Data Solutions, LLC
www.docsol.com
Time Matters AIC
HotDocs Certified Consultant
GhostFill Certified Consultant
"Del Murray" <XXXX@XXXXX.COM>writes