Re^3: Perl Query Locks A MsSQL Database

[Corion]

in reply to Re^2: Perl Query Locks A MsSQL Database
in thread Perl Query Locks A MsSQL Database

Actually, yes, your $GET_DB_DATA statement handle will be active and maybe MySQLMSSQL prevents other queries from updating the table. I recommend reading all data before trying updates.

Update: moritz spotted the wrong database

[EEddieEmm]

That was it.

I put all the data returned from the SELECT query into a 2 dimensional array, processed that and everything went well. Thanks for your help!

~Ed