True, but like I said, it was only one line of code in my situation. In fact, in my case, the memo field was just a logical expression like:

InList(acct,23,45,89) or Between(acct,1,18)

Then I could do:

lField = table.memofield
If &lField
Do something
EndIf

Then, I could change the memo field at run-time and the changes would take effect immediately.

Another alternative would be to put your code in a prg, run it, then copy the contents of the fxp into the memo field. I think that works, but you lose the ability to change code at run-time without having a compiler.


>Note that macro substitution won't work if you have more complex structure like SCAN, IF or DO WHILE.
>
>>I've supplied code in memo fields with an executable before. Of course, in my situation it was only one line of code. I used macro substitution on the memo field. You could do the same by reading the memo field one line at a time. But if you have a lot of code, it may get slow, I'm not sure about that. Anyway, it's an idea (and it works, too!).