On 12/5/06, Carlos M <[EMAIL PROTECTED]> wrote:
So, if you need to see the changes you should set AutoCommit to true before the UPDATE statement (the COMMIT statement is not necessary to use in this case).
I did not tested it, but IMHO all SQL commands see changes to data done within transaction they are in. It menas SELECT will see changes done by previous UPDATE statement, because the UPDATE was executed in the same transaction. -- Peter Bozek _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
