I have a program that I believe needs to lock down
a table for a sequence of inserts. I do not want anyone
inserting until I am done. Isn't this the concept of transactions?
I am programming in perl using DBI, and I was reading
through the ref but I don't quite get it. Anyone familiar
with this?
Here is the general layout.
Lock table
Select max num from table;
A bunch of inserts
Unlock table.
Anyone know how? HELP PLEASE!!!!! I would take a good reference
if you don't have the time!
Richard Trice