Re: scope of WHENEVER statement

From: "Pirn, Peeter" <PPirn@lnc.com> > >If I have a WHENEVER statement somewhere else than in main(), will it not >catch SQL errors in main()? Will it catch all SQL errors in functions (in >functions...) called by the function in which it was defined? I seem to recall that WHENEVER ERROR is a compiler flag -- so it depends on where it is in the program, and it is valid from there to the end of the file (or the next WHENEVER ERROR). HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com