Re: Before...During...and After

[ANDERSD2 <ANDERSD2@OAKWOOD.ORG>]

I find myself going to the book nearly every time I use BEFORE/AFTER just to
make sure I still understand these things.  BEFORE executes just prior to
the first row selected from your BEGIN-SELECT statement in ascending order.
Then, while within your BEGIN-SELECT, all DO (and other commands) are
processed.  Then AFTER procedures are executed in descending order once a
change in value is detected.

BEFORE - Ascending Order
Select - Sequential Order
AFTER - Descending Order
BEFORE - Ascending Order

Think BSAB (Ok, made it up, but may hold in your mind:))