>Very very well done, David!! Maybe MS will find room for this in subsequent documentation.
>
>Cheers,
>
>Jim N
>


I agree, the explaination was excellent.

One point I might add is to try to avoid macros if at all possible since I think they pollute memory. Your first example could be written:

IF UPPER(myOffOnStringVariable) = "ON"
SET EXCLUSIVE ON
ELSE
SET EXCLUSIVE OFF
ENDIF

Which will run more effeciently.

Macros are incredibly powerful, but I use them only in stituations that cannot be handled with regular code, name expressions, or the EVALUATE() command.

David,