If and when (don't you hate it when you can't get time for research!) you get this working, I'd love to see the specifics! Thanx!
>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.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
