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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement