2. ASPRunnerPro General questions
  3. Record Locking ASPRunner 6.3?
This topic is locked

Record Locking ASPRunner 6.3?

 		1/14/2011 4:58:13 PM
ASPRunnerPro General questions
G
 GerryT author

ASPRunner 6.3
I am trying the demo of 6.3 to see if it does what I need it to before I upgrade to it.
I selected record locking and auditing. Record locking is only on the main table. I created two different user names "admin" and "test". When either user goes in to the a record to edit it will create a log in the locking table, but when I click save record it does not release the record so another user can edit it. Only the same user can edit it. I have verified that I have it set to all users can edit any record.
Any help, if not i can upload it to the demo account and submit a ticket if needed.
Sergey Kornilov admin 1/14/2011

Do you leave the edit page after it was saved or stay there?

If former - record is still locked locked.
If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.
G
 		GerryT author 1/14/2011

Thank you, that is exactly what it was. I had it redirecting to the listing page after it was saved. Where/how can i redirect it after it is saved and still have it unlock the record?
Also for logging in using a username/password what is the default timer for it to timeout? Is there a way to change that variable? if so where?
Thanks again, this is why I use your product awesome support. Looks like its time to upgrade <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55668&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 1/14/2011

An excerpt from http://xlinesoft.com/asprunnerpro/docs/audit.htm

If user goes to the Edit page and then clicks Back, it turns out that the record remains blocked. To prevent this, automatic unlocking method is used. By default, the record will be unlocked after 300 seconds. You can change this value by editing the file include/locking.asp:

this_object.ConfirmTime = 250

this_object.UnlockTime = 300
The variable ConfirmTime determines how often the Edit page sends confirmation that the record is still locked. The variable UnlockTime determines the time (in seconds) after the last confirmation when the record will be unlocked automatically.


In other words you can customize it in include/locking.asp file.
G
 		GerryT author 1/16/2011

Thanks, I was refering to setting the timeout on the individual logged in with their username (example: i login as admin, after 20 minutes it auto logs me out). I am not sure what the default is or where I can set/modify that.
Another thing before upgrading to 6.3. With the dynamic permissions and record locking in 6.3 if you are in the "admin" group you get to see the user that currently has the record locked, the duration of time they have been in the record then the options to edit or unlock the record. Can this be set so you can have other users get this access without being in the "Admin" group?
THanks
Sergey Kornilov admin 1/16/2011

Session (login) timeout can be set per website only. You can change session timeout in IIS settings. Default session timeout is 20 minutes.
Record will be unlocked after one of the following events:

  • user who locked the record left Edit page
  • lock times out
  • admin (Admin group) user unlocks it
    There are no any other ways to unlock the record.