in reply to Re: Perl Query Locks A MsSQL Database
in thread Perl Query Locks A MsSQL Database
I can update the database directly. As a matter of of fact, that's how I "get around" the issue at the moment. I read the log and when an update is needed, I'll go into the database with Microsoft SQL Server Management Studio, and make the update with the data from the last log entry. Sucks, but it works.
Being new to DBI, I didn't know how to do this. You are right, might be worth a look although I know where the problem is. Just don't know why.
I was thinking along these lines myself. My plan was to alter the code to place the returned data into an array. Then read through that and make updates as needed. The while loop might be keeping the SELECT active somehow - don't know.