>>I am trying to create a recordset to pass data to a DLL. The problem is that I need to populate the recordset before connecting to the data source (the DLL does the connecting).
>>
>>I've tried different things but cannot open the recordset without a connection.
>>
>>Am I missing something or can this not be done?
>>
>>TIA,
>
>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