General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only