The first expression is only valid in SQL. You'll have to parse it in order to apply directly to a table. The query route may not be as bad as you think
lcExpr = 'Trans.cProduct_Line_Code between "100" and "200"'
lnPK = Trans.pk
SELECT * FROM Trans ;
WHERE Trans.pk = lnPK AND &lcExpr ;
TO SCREEN NOCONSOLE
IF _TALLY > 0
ENDIF
>Here is my problem:
>?evaluate()
>
>?evaluate('between(Trans.cProduct_Line_Code,"100","200")')
>
>In user's profile we have logic specified in the first form. In my code I'm attempting to check, if the current record in Trans satisfies the profile logic.
>
>How should I change my code to make sure it always work correctly? I wanted to avoid using Select SQL and just apply logic directly to the Trans file.
>
--sb--