Charlie:
Thank you for the information, it is highly appreciated.
Two additional questions?
1. What do you mean by "BIND" - as you stated
"bind it to your form controls"?
2. I'm using the OLE DB Provider for MS SQL Server 7 (not thru ODBC).
Doesn't the UPDATE/UPDATEBATCH handle the backend update - I can't
find a INSERT for OLE DB Providers?
Thanks in advance for all you help.
Mal
>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