Home » Developer & Programmer » Forms » multiple access of form (locking problem)
multiple access of form (locking problem) [message #272653] Fri, 05 October 2007 16:11 Go to next message
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i have developed form with 6 non database fields and populate them from table at run time with the user data who is currently login.
now,that user can open this form at multiple location(e.g user 143 using form on two terminals).
i want if user choose some fild to edit then it should lock for other or other one can only see it untill first one make edit.
how to do this??
or any other better idea to handle this?
Re: multiple access of form (locking problem) [message #272692 is a reply to message #272653] Sat, 06 October 2007 04:20 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Locking non-database items? I'm not sure it can be done.

But, why don't you make them DATABASE items instead? Or even use the FROM clause as a data block source and try with the FOR UPDATE option (I didn't try it so - perhaps it isn't possible at all, but you might give a shot).
Previous Topic: How to create and display text items on runtime?
Next Topic: Check Box in Forms
Goto Forum:

Current Time: Sat Jul 22 06:25:51 CDT 2017

Total time taken to generate the page: 0.18171 seconds