| Forms locking [message #311043] |
Thu, 03 April 2008 05:16  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
Hi,
I have a screen where two users works from differnt location on the same screen ,which updates the same database table.
So when one user opens the screen and updates some fields on the screen, which is a database item fields
and will not save the record.
At the same time another user opens the screen and he also updates some field at this
moment it locks.
But in my project it is like both the user opens the screen ,talk on phone and both should be allowed
to update the fields.
how can i do this?
Thanks,
Srinivas
|
|
|
|
|
|
| Re: Forms locking [message #311314 is a reply to message #311194] |
Fri, 04 April 2008 01:18  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
Hi,
May be i have to still explain in detail.
Same screen they are operating and 2 users are on phone.
User 1 and user 2.
The record they are updating is an emp record ,of same emp_id.
But user 1 can update only salary field.
user 2 will update the address or any other changes.
both are doing the changes different fields but same record and different session and no one is giving commit.
Thanks,
Srinivas
|
|
|
|
|
|
| Re: Forms locking [message #311395 is a reply to message #311043] |
Fri, 04 April 2008 06:37 |
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
|
Senior Member |
|
|
Only way i see to do that is basing your block on a procedure instead of table. The block will pass the record structure to the procedure and in the procedure you write your code to do the update. You also have to overwrite the on-lock trigger in the form.
This should work since form will no longer lock the table. The lock will be only when the update in the procedure will be executed. So except if the 2 user are comitting exactly at the same second it should work.
Hope it help.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
