Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Stale results from SELECT

This question is answered.


Permlink Replies: 1 - Pages: 1 - Last Post: May 24, 2012 10:24 PM Last Post By: Hans Bergsten
Benjamin Flynn

Posts: 1
Registered: 05/24/12
Stale results from SELECT
Posted: May 24, 2012 8:04 PM
 
   thread.click_reply Reply
If I use the SQLCommander to do a select, use a different tool to do an update, and use SQLCommander to do the same select, the old value is returned. If I reconnect to my database with DBViz, my new value is returned.

How can I get the new value without reconnecting to the database?
Hans Bergsten


Posts: 1,577
Registered: 10/11/06
Re: Stale results from SELECT
Posted: May 24, 2012 10:24 PM    global.in_response_to.tooltip in response to: Benjamin Flynn
Correct
   thread.click_reply Reply
Hi Benjamin,

You need to set an appropriate Transaction Isolation Level in the Physical Connection category for your database in Tool Properties or in the Connection Properties. The Read Committed level is most likely what you're looking for.

Best Regards,
Hans

Point your RSS reader here for a feed of the latest messages in all forums