Subject | Re: DDL updates in 2.5 |
---|---|
Author | Aage Johansen |
Post date | 2011-11-21T19:12:01Z |
Martin Agren 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.
up in the results? I don't think the SP is recompiled until the
database is closed and reopened - it could be difficult to recompile
for you and keeping the old one for other users. OTOH - I could be mistaken.
--
Aage J.
<<
...
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.
>>Will your stored procedure need re-compiling before changes will show
up in the results? I don't think the SP is recompiled until the
database is closed and reopened - it could be difficult to recompile
for you and keeping the old one for other users. OTOH - I could be mistaken.
--
Aage J.