I would recomend that you take a look at DataClass2000 at http://www.takenote.com/dc2000.htm for adifferent approach. It uses SPT + stored procedures (SP) to retrieve data and ADO + SP to write data back. You can download DataClas 2000 Evaluation Documentation at http://www.takenote.com/files/dc2000.zip

>We're starting a new VFP/SQL Server project and have been discussing the benefits/pros & cons of using remote views versus SQL passthru. We'd be interested in any opinions on this debate and experiences from your point of view and work you've done/are doing.
>
>By the way, this will be done ourselves, we're not interested in a framework or "tool" to do this for us. :)
>
>Thanks.