Question Editing locked records..

[Petros]

Hi, is there a way to display who “else” is editing the same record i am currently working on, i do receive a “sound”..but i need also to identify the user..is this possible?

Thanks!

 

[the_net_2.0]

You know...one way (that should be the last option) would be to record the user data on the "on current" event of the form. You can store it anywhere, be it a table or a variable. In that scenario, you can retrieve the information at will from any copy of the front end.

 

[gemma-the-husky]

Hi, is there a way to display who “else” is editing the same record i am currently working on, i do receive a “sound”..but i need also to identify the user..is this possible?

Thanks!

its not yourself is it. sometimes you can have two forms open at the same time, which causes this problem.

secondly, does this mean you have some record locking turned on. Personally, i wouldnt bother. optimistic record-locking is generally acceptable in most cases. once you turn record-locking on, you do have to think about design, so that the user with the lock will hold the lock for the least time possible, and release the lock asap. You dont want a user opening a form locked, and going to lunch say, leaving a record locked for an hour or more

 

[Petros]

its not yourself is it. sometimes you can have two forms open at the same time, which causes this problem.

secondly, does this mean you have some record locking turned on. Personally, i wouldnt bother. optimistic record-locking is generally acceptable in most cases. once you turn record-locking on, you do have to think about design, so that the user with the lock will hold the lock for the least time possible, and release the lock asap. You dont want a user opening a form locked, and going to lunch say, leaving a record locked for an hour or more

Thanks Gentlemen,

The frontend is distributed to 10 users and it does happen that i want to edit a record in a form that someone else is editing...Actually i wanted to be able to shout out “Jack, please logout from record 5”..now i have to shout out to ALL “Please log out from record 5”...( normally this is communicated via a “communicator”) J

 

[the_net_2.0]

Thanks Gentlemen,

The frontend is distributed to 10 users and it does happen that i want to edit a record in a form that someone else is editing...Actually i wanted to be able to shout out “Jack, please logout from record 5”..now i have to shout out to ALL “Please log out from record 5”...( normally this is communicated via a “communicator”) J

I think Gemma is right about locking like that, but I think I'll disagree on another point. In this man's opinion, you should always use locks if there is more than one person the database. That reduces risk, plain and simple.

As far as getting this done Petros, the suggestion I gave you would work fine but by no means is it 'catch all'.

 

[Petros]

Ok, i will go ahead and try your suggestion out...Thanks!

 

[the_net_2.0]

Ok, i will go ahead and try your suggestion out...Thanks!

You can probably do it more than one way. If you run into a stumbling block, post back and we might be able to help you out.