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.
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development