>>I was agree with Sergey (before I read this post), but you should think what will happens if you want to upsize your application to SQL DB. Maybe SELECT is better than just EVALUATE()? Also what will happens if _TALLY is greater than 1 (SELECT returns more than one record)?
>
>Good point about upsizing.
>
>If we have _TALLY > 1 for the cTrans_pk, when we have a much bigger problem! <g>
:o)))))
where cTrans_pk = m.tcTrans_fk ;
and &lcLogic to screen noconsole
I saw this as JOIN ..... WHERE &lcLogic
I don't know why :o))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.