--- In [email protected], Thomas Steinmaurer <ts@...> wrote: > > >> I use Flamerobin myself and it's always required explicit commits after > >> DDL statements. However, recently I discovered a convenient option (look > >> at the "SQL Editor" branch in Flamerobin's preferences) "Automatically > >> commit DDL statements", which does the trick. I admit I've no idea how > >> long the option's been there (my ignorance sometimes scares me) but it's > >> there and does what it says. > >> So, with the option unchecked, the script > >> > >> create table T ( > >> F integer > >> ); > >> > >> create index I on T(F); > >> > >> fails on create index, saying table "T" doesn't exist. When you put > >> comimt after create table and before create index, it works. > >> With the option mentioned above turned on, the commit is issued > >> automatically by Flamerobin. > >> The auto-commit is client-dependent. Long ago I used SQL Explorer > >> shipped with Delphi 4 and it could be told to auto-commit all (!) > >> statements. > >> > >> I hope that helped a little. > >> regards > >> Tomasz > > > > This has nothing to do with committing the DDL update. My updates are of > > course committed but are still not affecting the data from subsequent > > queries in a new transaction context. Not until I disconnect the tool and > > all other connected applications. > > > > I guess that either is data cached somehow, or is the metadata change not > > visible. > > > > Is there noone else that experienced this?? > > Do you experience that you don't see the DDL changes after the commit in > the same connection or do other connections won't see the changes? > > > -- > With regards, > Thomas Steinmaurer >
Data output from my stored proc isnt reflecting the changes I have made. I make changes in DDL, check the "new" dataset (Flamerobin or my client app) and am not getting the desired results as data is unchanged. I make another change, still no effect. Then, when disconnectiong and restarting my client side apps all the changes suddenly appear. Very frustrating.. :) /M
