When you lock tables, you must lock ALL tables you intend to read
or write.
You previously locked tables, and then did a select from bookings.
You did not include bookings in the lock.
Don Pro wrote:
Hi,
As the subject states, I am getting an error in my Perl script telling
me that a
Hi,
As the subject states, I am getting an error in my Perl script telling
me that a table is not locked yet all I am doing is a SELECT. Why do I
need lock a table in order to issue a SELECT?
The code in question is:
$sqlCmd = $dbh-prepare(q{
SELECT Booking FROM Bookings where