| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Forms 4.5, views and instead-of triggers
Hi,
We're using Forms 4.5 against an 8.1.7.1.4 database. The database is on NT4 and clients are on NT4, W2K & XP.
1 of the forms is based on a view which joins 2 tables (by an equi-join on 2 fields) and has an instead-of trigger in place.
If I update a field in that view from SQLPlus, a lock gets taken out on both of the base tables - as I would expect.
When a record is modified in a Form based on that view, a lock initially only gets taken out on 1 table - the lock is always on the same table and sometimes not even on the table the field being modified is from.
The problem is this allows another form to change the same record and we can end up with changes get overwritten by other users.
I'm not a Forms developer but am hoping someone else may have a suggestion on how to get the form to put locks on both tables or whatever other suggestions come forth. I can then pass these onto our Developer.
Also, is anyone else using Forms 4.5 with Instead-of triggers?
Thanks,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jun 23 2002 - 20:23:18 CDT
 |
 |