>>Drew Speedie was famous for saying "Tricks are for Grids".
>>Are tricks also for "Set Procedure To"?
>>This is anecdotal admittedly, but twice in the last year the mere act of setting procedure to MyProgram Additive has "shot me in the toe" (so to speak).
>>In one case merely setting procedure caused an immediate corruption of a table. This was repeatable.
>
>I suggest to NOT use functions from procedure files in Index's Key and FOR expressions. Even if the procedure file is already open when the table is open, reopening the procedure may confuse VFP and corruptions may occur. Such function calls should be either standalone program files or as a Stored Procedure so they are visible always.
>
>>In another case merely setting procedure to MyOtherProgram additive caused a running form to close.
>>i can't possible count how many times i have set procedure to xyz program since 1994.
>>So what is it i don't know about "Set Procedure"? Much i am sure.
>>
>>Dumb as a post here

Thanks Greg,

It's not germane in this case but good advice nonetheless and i will keep in mind going forward.
I do use function calls within queries occasionally.