Thanks. If I know that it's potentially doable then I'll experiment.....

>>Sorry, maybe I was not clear enough.
>>
>>Can I have a SP that, for example, has 'DO xxx.prg' where the prg is an external file?
>
>
>Think you can, Viv
>
>(1) prg and functions/procedures
>
>Make sure that all PRGs are reachable ( with set procedure to .. additive')
>
>or
>
>do xxx in path\filename
>
>
>(2) As to the classlibs -
>
>you may have to do 'Set classlib to ... additive'
>
>or
>
>obj = newObject(classname, fullPathOfVcx
>
>
>
>
>
>>Asking because the prg in question performs a lot a recursive logic (using several class libs) across multiple tables and I need to get the results back via OLEDB to .NET
>>
>>The alternative would be to reconstruct the same logic in C# which would be time consuming....
>>
>>
>>>>Is it possible to call a prg (or, come to that, a class method) from a stored proc. in a VFP DBC ?
>>>
>>>Yes. If you open DBC, then you can call procedure saved in DBC.
>>>
>>>MartinaJ