>>>>>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
>
>Yep, that's when 2 "."s are required, one to terminate the macro and one for the "." separator between object.property/table.field names.
>
>>
>>I assume the EVALUATE() is faster though.
>
>Unless it's in a loop and executed lots of times, I doubt that you could tell the difference.

Hey...every nanosecond counts! hehehe