>>Its hard to sell RVs with "enterprise" systems.
Erik,
PMFJI, but thisis driving me nutty. you once again are arguing a line that is highly frustrating because you say "why" to every answer you get. it's kind of like;
Stealing is wrong.
Why?
Because it takes a way a person's rightful property
Why is that wrong?
because each person has rights to life . liberty, etc.
Why?
and on ad nauseum ...
The point is that MANY best practices can not be summed up in an easily communicable set of neat rules. They come from real world expereince, trial and error, mistakes, etc. and - very importantly - rubbing shoulders and ideas with others who are out grinding every day on this stuff and succeeding at it.
I haven't bothered to look at all the messages in the thread, but Why SP over RV? Here are some simple answers:
1 - no VFP DB - solves many distribution and upgrade headaches
2 - RV is NOTHING BUT A WRAPPER for SPT and SPT is better served calling SP
3 - SP afford you easier migration to different front ends
4 - more secure because you can lock tables down and deal with access through SP rights.
5 - Less netework traffic
6 - Inherently faster due to caching
7 - My SP based solution will walk all over your RV based one in every aspect.
If you don't get it - then there is really nothing that could be said to make you get it. You are very smart and have a lot of good input and skill. I have learned things from you and your posts and appreciate your contributions to the forum. You, do, however - amaze me at times with the position you take up on certain issues.
Finally - if I've missed something due to not reading the whole thread - please forgive me in advance.
Ken B. Matson
GCom2 Solutions