>>Rich,
>>
>>My reasoning for the FOR clause addition is simple...
>>
>>This clearly doesn't ever want to handle deleted records and putting it in the SCAN ensures that (ever) changing the SET DELETED setting will not impact this routine. It also makes it obvious to the developer whenever that routine is examined.
>>
>>Cheers,
>>
>>Jim N
>
>That makes perfect sense. Thanks for responding.
>
>Rich.
P.S. - in every app I ever developed, SET DELETED ON was in the app setup prg (or DELETED=ON in config.fp(w) ), and it was never turned off, so I almost never wrote FOR NOT DELETED() in anything.
The only exceptions were a few apps which had setup code like:
IF < I determine it's a Developer running the code >
SET DELETED OFF
< and other development-time stuff >
ELSE
SET DELETED ON
< and other normal running stuff >
ENDIF
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing