At first glance, this looks like a good approach. However, I think you will still need VFP 6.


>One way to approach the problem is to send the whole recordset back to VFP as an object. The by using the properties contained in the Fields collection you can build a cursor (CREATE CURSOR...) with the required structure. Once this is done you can you the MoveNext method to insert the data into your cursor. You could then create a method that would then update the original recordset object and pass it back to the server.
>
>I am currently researching this solution with a 3-tier system, but I am using Oracle as the back-end and writing the middle tier in VB and using Oracle's Objects for OLE instead of ADO (their almost identical in properties and methods). I'm only working on this when I have time so I'm not developing this full-time. If I finish my research and decide that this is an acceptable solution I can give you more specific. If you try this and like it, let me know.
>
>
>>You probably need VFP 6 to do this.