better to use some sort of username rather than just a bit column to
indicate a lock... also a timestamp that the record was last modified
then you can do a scan every twenty minutes and if it has not been
updated in 20 minutes you can assume that the user is no longer looking
at the record and you can unlock it for others to use
[ also let's you inform your user's who has actually locked the record ]
--
David
-----Original Message-----
From: Taco Fleur
Sent: 21 April 2004 12:29
To: CF-Talk
Subject: RE: Locking Records!
just add another column to the table, call it "locked" of type BIT and 1
is locked and 0 is unlocked
Taco Fleur
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
