Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Forms 6i and Lock Stored Procedure
- Thread starter King30
- Start date
I assume from this you have a block that is based on a stored procedure. If this is so you have to code all the DML yourself within the procedure, including a procedure to lock the table or rows. You then set the Lock Procedure... set of properties at the block level to point to your lock procedure.
Within this proc you can issue a LOCK TABLE command to lock the entire table, or use FOR UPDATE to lock individual rows for example.
Within this proc you can issue a LOCK TABLE command to lock the entire table, or use FOR UPDATE to lock individual rows for example.
- Status
Similar threads
- Locked
- Question
- Locked
- Question