>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.
Gosh David,
I thought that with the advent of structured programming and OOP worrying about memory pollution was passe (well...at least in the halls of MS land)...hell, memory's cheap...<g>
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum