locking of records

vincentc · August 19th, 2003, 01:34 AM

I want to lock the record (e.g. invoice)
when the browser load the page and unlock the
record when the browser left the page.

Can ASP handle this case?
If the client machine halt, how can we release the lock?

pgtips · August 19th, 2003, 03:54 AM

I would advise against actually applying a database lock to the record. Better to add some new fields, e.g. LockDateTime and LockUser, and fill these when the browser loads the page and clear them when the browser leaves the page.

You can then handle the client halting by looking at the new fields the next time a user wants to see the same invoice. For example:
- if another user requests a locked invoice, compare the current Date/Time to the LockDateTime field and if its more than, say, 20 mins ago (you need to decide a reasonable interval for your users) allow the new user to view it and update the LockDateTime and LockUser with new values
- if the same user request the invoice again, let them view it and update the LockDateTime.

You can also schedule a database job to clear out the values in LockDateTime and LockUser at suitable intervals (again you need to decide what is reasonable for your application).

hth
Phil

vincentc · August 19th, 2003, 04:19 AM

How can i clear the lock when the browser leave the page?
Is there any method to clear the lock when the user
click the "X" of the IE to close the window?

pgtips · August 19th, 2003, 04:24 AM

You can use javascript function trigerred by onunload event of <body> to send data to an ASP page to clear the lock.

mega · August 19th, 2003, 04:40 AM

I guess you could do something like this:

<body onunload=exit(<%= Request.Session)>
<script language="JavaScript" type="text/javascript">
  function exit(sessionID){
    document.write('<img src="releaseLock.asp?ID='+sessionID+'" width="1" height="1" alt="">');
  }
</script>

Regards - Jon