First of all congratulations for this new product “Toad for Sybase” that our team of DBAs welcomes with enthusiasm as we are happy with “Toad for Oracle”!
I am having a problem with the Autocommit feature in the freeware version of Toad for Sybase v1.0 (installed on Windows XP) connected to a Sybase 12.5.3:
Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006
1- I create a new table test (the new table does not appear in the list of tables so I click on “refresh” and it is ok) by running: create table test (foo char(5))
1- I disable the Autocommit by clicking on the button “Autocommit” at the bottom left
2- Click on refresh button (just in case)
3- I run “insert test (foo) values (‘test1’)”. I can see the new row with a SELECT.
4- I click on “rollback transaction” and see “Connection Rolled back”.
but I still see the inserted rows. I double check a SELECT within a sqsh on the Sybase server but the row is still there.
Do you have any idea?