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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only