Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO & VFPCOM Help
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00263209
Message ID:
00266713
Views:
26
Malcom:

DCOM is not an object, it is the technology that lets you call methods on a COM object that is located remotely on a nework.

To get a RS to the front end, create a method on your COM object to receive the query parameters from the front end, run the query, convert results to a RS from a cursor, then the last line of code in the method will be 'RETURN oRS.' When you recieve the RS on front end, bind it to your form controls.

To update the backend, have a method in your COM object to recieve the RS from the front end, then convert it to a cursor and loop through it issuing SQL update or insert statements. The primary key will be what you use to determine whether you issue an update or an insert.

Getting recordset to front end:
oServer = createobject('server.myserver')
oRS = oServer.GetRS(SQLparms)

Updating backend:
oServer = createobject('server.myserver')
= oServer.Update(oRS)

Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform