--- In firebird-support@yahoogroups.com, 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