Methodologies for locking Master/Detail/Detail relationships.

I have the following relationships:

• Table1 is a master table.
• Table2 is the detail to Table1.
• Table3 is the detail to Table2.

Using PL/SQL, Pro*C, Forms 4.5: when I lock a record in Table1 I want to lock the corresponding rows in Table2 and Table3.

Forms 4.5, I'm pretty sure, does this sort of thing by itself. Is this correct?

With PL/SQL and Pro*C, I've used "Select ... For Update" on each of the tables. I'm I using the correct approach? Are there alternatives?

Any advice would be appreciated.

Thanks. Jeff. Received on Fri Oct 24 1997 - 00:00:00 CEST