Re^3: Perl Query Locks A MsSQL Database

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 ~~MySQL~~MSSQL prevents other queries from updating the table. I recommend reading all data before trying updates.

Update: moritz spotted the wrong database

Comment on Re^3: Perl Query Locks A MsSQL Database Download Code

Replies are listed 'Best First'.
Re^4: Perl Query Locks A MsSQL Database by EEddieEmm (Initiate) on Jan 23, 2013 at 20:38 UTC
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	[reply]

In Section Seekers of Perl Wisdom