Are stored procedures best location for UDF required in view?

[Nifrabar]

Hi!
I am creating a view which needs to have calculated values.
Before I used functions, stored in the main.prg.
I feel this is not best solution.
Now I overthink to use stored procedures.
What's the opinion in this forum about that?
-Bart

 

[Mike Lewis]

Bart,

There are arguments for and against stored procedures.

In this case, the main advantage would be that they make the view more self-contained. Since the view and the procedures are in the same physical file, you more or less guarantee that the view will find the calculations it needs.

Interesting to hear what others think.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Nifrabar]

Mike & Mike,

Thanks for your reply.
My DBC will 'once' be on a shared location.
EXE's always on the local machines.

From your replies I understood that we all have in fact same opinion on this issue.

-Bart