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?
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.