Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCATTER and remote views
Message
 
To
20/09/2002 21:50:37
Raul Davila
Davila Programming Services
Toa Alta, Puerto Rico
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00702991
Message ID:
00703099
Views:
17
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 Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform