>>>>>Mixing dot notation and macro expansion or eval() always trips me up.
>>>>>In the "condition" field of the patient table is a logical expression that I want to evaluate to .T. or .F. Note: I need to refer to both the table and name since in my actual code there are two tables.
>>>>>
>>>>>select patient.name from patient where eval(patient.condition)
>>>
>>>>Give us a sample of the contents of the condition field.
>>>
>>>I can be ".T."
>>>or it can an expression that evaluations to T/F such as "HepBStatus(id) = 2"
>>
>>The first will work. The second won't unless HepBStatus is a program.
>
>HepBStatus() is a valid function that is loaded. What do you mean by "a program"? A function/procedure?
Yep! Is id a field in the table?
George
Ubi caritas et amor, deus ibi est