Laser Lips wrote on 02 mrt 2010 in comp.lang.javascript:
Not as simple as all that.
As much as I hate topposting, this full bottomquoting is also not
perfect. So please skip all irrelevant parts, like the signature.
Any good newsreader will do the latter for you automagically.
And start interposting.
While a user has a record open that record is locked to all other
users.
So that is clearly not the way to do it. If you cannot use a roll back
mechanism, just do not process the data till everything is ready for the
final datetranfer tot te database.
The record locking should be only miliseconds long.
The mechanism we use to lock a record is CACHE's built in one.
So if it is a bad system, don't use it.
Is this ASP?
VBS or Jscript?
or is this a com?
We could use temporary tables to flag locked records and use temporary
storage until user is ready top commit data back to the DB but this
means a whole software rewrite and many site updates, so it's out of
the question.
Your choice. If it is too much work to better the procedure, it usually
is the logical alternative option to keep using the bad and the ugly.
All records are unlocked after 15 mins or a session timeout, but the
intermittent waiting is a real killjoy.
Quite so.
You should be able to shorten that timeout to 1 minute, but still ...