got a problem...locks [message #137297] |
Wed, 14 September 2005 07:37 |
prase_pk
Messages: 40 Registered: July 2005 Location: india
|
Member |
|
|
I am using forms for a multi user environment.This is my scenario.
Suppose one user opens the form and if he enters some data into 2 fields 'X' and 'Y' which is a composite primary key.
and now
Suppose one more user opens the form and if he enters the same data then both the forms are getting hanged.I think it is a problem with builtin lock.
I think the information which the user1 enters is not yet saved or committed and so it is stored in the forms buffer.
Then how come the second user is unable to enter into the fields?
Primary key and other exceptions...I am handling....even then I am getting this problem...please help
|
|
|
|
Re: got a problem...locks [message #137375 is a reply to message #137297] |
Thu, 15 September 2005 00:00 |
prase_pk
Messages: 40 Registered: July 2005 Location: india
|
Member |
|
|
it is not a database block....and I am not using the same fields ,I am using the fields which relate to the above fields and the insertion is just for this field...
I am giving a select statement from one form and based on this select statement ,I am giving an insert statement.
|
|
|
|
Re: got a problem...locks [message #137391 is a reply to message #137297] |
Thu, 15 September 2005 01:28 |
prase_pk
Messages: 40 Registered: July 2005 Location: india
|
Member |
|
|
Fine david,
but can u tell me one thing.in forms when an insert statement is used,does it have a lock on the table in which we are trying to insert?
|
|
|
Re: got a problem...locks [message #137393 is a reply to message #137391] |
Thu, 15 September 2005 01:35 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I wouldn't have said a 'lock' but you are the only person who can 'see' your new record until you do a 'commit'. But as you are not using a database block you may find that a 'commit' or 'commit_form' will not 'save' your work. Use 'standard.commit' instead.
David
Keywords: lock, locking, insert, inserting, update, updating
[Updated on: Thu, 15 September 2005 18:27] Report message to a moderator
|
|
|
Re: got a problem...locks [message #137446 is a reply to message #137297] |
Thu, 15 September 2005 04:48 |
prase_pk
Messages: 40 Registered: July 2005 Location: india
|
Member |
|
|
no david my problem is not resolved...
I am using an insert statement,but the insert statement is creating a lock on the form and when I am trying to insert the record as some other user..its getting hanged.what to do?
|
|
|
|