>>My personal opinion is never to use remote views.
>
>>I am in situation where I must convince a consulting company that is writing a VFP app for us that Remote Views are not the way to go and to use SQL Pass through. Politics are such that I must have documentation backing up my requirement to drop remote views.
>
>Hi Fred,
>
>It looks like you have enough advice on how to back up your opinion, one which I agree with. I've never used RV's. In fact, I'm currently working on converting a VFP app's back end to SQL Server. The application uses local views and I'm still going to use SPT.
>
>But I don't understand why you (the client) must convince the consultants (your vendor) to use SPT. Make them convince you that RV's are the way to go. Also, I'ld be concerned with their experience with C/S apps. Even if you convince them to use SPT it doesn't mean they'll use it efficiently!

George;

Perhaps the consultants:

1. Know something the rest of us do not.
2. Do not know any other technique.

It is sometimes hard for an employee to convince a company they know anything. Consultants are treated like demi-gods by many companies as persons with infinite knowledge and wisdom. I have been on "both sides of the fence".

Questioning a consultant can find displeasure with the company you work for. After all you are in effect questioning your companies ability to make “business decisions”. Politics is all a part of the game. It does not matter how “right” you are – just how you play the game.

Tom