This has magnificent potential for cockups, if you now try and SQLExecute the 'new' statement and get the old one in its place!
DO NOT assume that a prepared statement is still valid after you've called SQLEndTran - prepare it again!