Subject | Re: [ib-support] Direct modification to system tables to... |
---|---|
Author | Jason Wharton |
Post date | 2001-07-10T07:27:56Z |
> Just be crafeul when there are dependencies on that field in (forThanks for the additional tips. How about if I just go through and alter all
> example) stored procedures.
> Check these dependencies before you alter the domain.
> If necessary alter the procedures to an empty body, change the domain,
> change the procedure (and it's variables) according to your needs and
> then re-add the procedure.
the stored procedure so that they are recompiled? I am not certain I made
sure all of these dependencies were eliminated.
I usually do this when I am changing the stored procedures input parameters
and such so I'm used to the commenting stuff out. That is a very useful
suggestion for sure. In fact, I just got done changing a bunch of stored
procedures doing that...
Seems I need to add a column dependency tracker to IB_SQL (notice I don't
call it IB_WISQL anymore since we are LINUX bound).
Cheers,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com