>>>I've seen it used a LOT in building up SELECT statements, if you have a form that has various check boxes and selections etc., then the validation will build up the WHERE clause to include in a single statement.
>>>
>>>SELECT * FROM myTable;
>>>&lcWhereClause
>>>
>>>Kev
>>
>>
>>Ok, Ok, Ok. I should have excluded SQL statements. I use it for this too, just because we don't have a choice. Notice however that VB programmers don't need macro substitution to run ad-hoc SQL statements, because they have avenues for submitting SQL as a string. I've been lobbying for a VFP equivalent for some time now.
>
>I used macro substitution and eval statements for a VFP 6.0 application I designed that uses a data-driven rules engine.
EVAL is valuable, I agree. Macros, I'm not so sure about.
Erik Moore
Clientelligence