Actually that's the way I do it most of the time, putting as much funcionality as I can on stored procs in SQL Server.

This project was passed on to me from another developer and he did everything in a dbc. Since they gave me a short deadline, I opted not to convert the old code, but to use the existing dbc and the remote views.

>Hi Raul,
>
>>Hi,
>>I'm having a problem in VFP6 where SCATTER is not working corectly with a parameterized remote view.
>
>>Any ideas?
>
>Oh, I have a couple. < g >
>
>First, why are you SCATTERing in the first place? Are you binding these m. variables to form controls? Why not use the viewname.fieldname to bind instead of the m. variable. Or better still, why not great a data object that has a method that passes your primary key into a SQL Server stored proc to retrieve the record you want. Once that record set returns, you can do a SCATTER NAME InsertTheNameOfYourDataObjectHere and bind to the properties on that object.
>
>Here's an another idea... you could add Save, Delete, and Add methods in addition to the Find method I described above. Each of those methods would pass parameters (your field values) to an appropriate stored proc on the server.
>
>Using this methodology you remove your dependance on remote views and the DBC.
>
>Just something to think about... let me know if you'd like me to elaborate on this methodology.