--- In [email protected], Mark Rotteveel <mark@...> wrote: > > On Mon, 21 Nov 2011 08:59:30 -0000, "martin.agren" > <martin_gbg_@...> wrote: > > 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.. :) > > If you are using Classic that is - as far as I know - a known issue. Every > connection has its own metadata cache, so DDL changes are not always > directly visible to other connections. Therefor it is usually advisable to > execute DDL in isolation. Why are you executing DDL as part of - I assume > - your normal application execution? It is usually advisable not to change > the database layout as part of the your application execution and only > change it when upgrading to a newer version of the application. >
Hi, No, I am using SS. And the DDL changes are never changed as part of application execution. But when developing, i often work from both Flamerobin and my app to see effects of metadata changes.
