Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO & VFPCOM Help
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00263209
Message ID:
00266713
Vues:
25
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform