>>I hadn't heard anything except grids, but the others would all makes sense as well. That would certainly KA.
>
>I am still not sure this ADO thing is the best way to go. Unless I am missunderstanding this thing.
>
>When an object is passed from a middle tier object to a front end ap, isn't it just a reference? So, IF MyApp on MyClient asks for some data from MyMiddle on MyServer...
>
>So, MyMiddle does something like...
>
>oConn = createobj('ADOBC.Connection')
>oConn.Open("dsn=MySource")
>oRs = oConn.Execute("select * from MyTable")
>
>return oRS
>
>Now... MyClient recieves that... isn't that a reference to an object that is running on MyServer? So, all the communications is still going over DCOM back to the server?
>
>Thanks,
>BOb
If you create a client-side recordset, then the data will be passed to the client. With a cursor-side recordset, the data stays on the server.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer