>>>>>>Michael,
>>>>>>
>>>>>>>Hmm..that was too easy. Why didn't I think of that? Sometimes I wonder if I'm not going through premature senility.
>>>>>>
>>>>>>That method will work, but only if you are running within VFP - a distributed executable doesn't have access to the compiler so cannot compile and run a prg file.
>>>>>>
>>>>>>If you want to re-distibute you could look for something called CodeBlock (which may be in the library here).
>>>>>
>>>>>If the code in his memo filed is a one liner, he could get the contents into a memvar and use either &Memvar or EVAL() to execute the one line of code..
>>>>
>>>>If it's multi-line memo then you can go through the loop:
>>>>
>>>>for n=1 to memlines(memofield)
>>>> cCommand=mline(memofield,n)
>>>> &cCommand.
>>>>endfor
>>>>
>>>
>>>Good point Ed... Hadn't thought of that..
>>
>>Ed,
>>
>>Would loop processing work with that setup? Something like:
>>DO WHILE ...
>>.
>>.
>>ENDDO
>>
>>I'm curious rather than accusatory. This would be great if it works, but I've always been under the impression that you're limited to 1 line commands with macro expansion.
>
>But number of these commands in your program is unlimited, right? So, it should work.
Ed,
So you're saying that if I had a memo field with the following in it:
SELECT foobar
ln_count = 0
SCAN WHILE foobar.item = "TEST"
? foobar.description
ln_count = ln_count + 1
ENDSCAN
? ln_count
That the following code would run it correctly through macro expansion?
for n=1 to memlines(memofield)
cCommand=mline(memofield,n)
&cCommand.
endfor
I tried something similar, but it didn't work. It generates an error when you try to macro expand the initial loop line. Any way around that?
Rod Lewis