Article View: borland.public.interbase.sql
Article #11283Re: Recompile SP
From: Craig Stuntz TeamB
Date: Mon, 02 Dec 2002 18:53
Date: Mon, 02 Dec 2002 18:53
17 lines
1667 bytes
1667 bytes
In article <3deb7e66@newsgroups.borland.com>, bojo@kodar.net says... > > It seems that if a SP changes all SPs calling that one have to > > be recompiled ? > > Yes. > Not exactly. Read about updating procedures in use in the documentation. If you don't want to update the other procs you can just have everyone (including yourself) disconnect from the DB. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<MPG.1855762b84f8224a98a2af@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp5.savvis.net!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!uunet!sac.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3deb7cbc@newsgroups.borland.com> <3deb7e66@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,3206af6518bf1270 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-02 10:55:51 PST From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> Newsgroups: borland.public.interbase.sql Subject: Re: Recompile SP Date: Mon, 2 Dec 2002 13:53:25 -0500 Message-ID: <MPG.1855762b84f8224a98a2af@newsgroups.borland.com> References: <3deb7cbc@newsgroups.borland.com> <3deb7e66@newsgroups.borland.com> Organization: Vertex Systems Corporation X-Newsreader: MicroPlanet Gravity v2.60 NNTP-Posting-Host: 65.86.87.242 X-Trace: newsgroups.borland.com 1038855114 65.86.87.242 (2 Dec 2002 10:51:54 -0800) Lines: 17 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp5.savvis.net!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!uunet!sac.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail