Did you try this code is Foxpro? I seem to bomb out on 'Set rsCh = rs("Child").Value' now 'rsCh = rs("Child").Value'
I get an invalid subscript error.
Dan
>It's possible. See
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q196029>
>>>
>>>Here is a simple example of doing this:
>>>
This.oDetlRS = CreateObject("ADODB.Recordset")
>>>With This.oDetlRS.Fields
>>> .Append("FileName", adChar, 15)
>>> .Append("Process_id", adInteger)
>>>EndWith
>>>This.oDetlRS.Open
>>>After this you can use AddNew to populate the recordset.
>>>
>>> If you would rather use a batch update, you need to persist an empty recordset obtained from the backend so that you won't need a connection in order to open and populate the rs at the client, and when you send it to the DLL you can BatchUpdate all rows at once. HTH
>>
>>
>>Have you ever created an empty shape? Just today I was thing about using the MSHFlexGrid which requires a shape. I'm not using ADO to get the data so I thought about creating and empty shape and filling it from Fox cursors.
>>
>>Can that be done?
>>
>>Dan