Greenhalgh David wrote: > ... > In other words, my SELECT block is returning the value of available as > it was before the UPDATE, even though I have AutoCommit set to 1, the > UPDATE is called before the SELECT and manual investigation of the > table clearly shows that the UPDATE was successful. This suggests to > me that even though AutoCommit is on, the commit does not actually > happen until the $dbh is released and the connection to the database > cut.
The setting of AutoCommit shouldn't matter. Your session should see all updates immediately. Commits only affect the visisbility of updates to other sessions. Something else is going on. Start by constructing a very simple, stripped down example that updates a row and then selects that row again so we can make sure the database is behaving properly. Verify that that example works regardless of the AutoCommit setting. I suspect something is amiss in the logic of your program that you just aren't seeing. Try stripping it down to the minimum code that still exhibits the problem and post the complete code. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
