>>>Hi,
>>>
>>>I have a table like the following
>>>
>>>Condnum Condition
>>>1 ALLTRIM(mytable.country) = "ITALY"
>>>2 ALLTRIM(mytable.country) = "GERMANY"
>>>3 ALLTRIM(mytable.country) = "SPAIN"
>>>
>>>I want to use this data in my code as follows:
>>>
>>>SELE mytable
>>>STORE mytable.country TO m.condition
>>>IF m.condition
>>> ...
>>> ...
>>>ENDIF
>>>
>>>This does not work. I have also tried
>>>IF &m.condition
>>>But that does not work either.
>>>
>>>What am I doing wrong?
>>
>>This might work...
>>
>>IF &m..condition
>> ...
>> ...
>>ENDIF
>>
>>
>>The reason is that a macro needs a '.' after it, so you will need 2 '.'
>
>Sorry Victor, that wouldn't work either. It would look for a macro named "m". As others have pointed out, you need to use EVALUATE() or leave off the "m." altogether.
Doooh! "m" would have to be a varable name to do it my way.
Select MyTable
lcCountry = mytable.country
IF &lcCountry..Condition
...
...
EndIF
I assume the EVALUATE() is faster though.
ICQ 10556 (ya), 254117