Array to ADODB recordset

11 Oct 2005 8:16 PM

Dan Reber

I am creating an array from multiple recordsets and use the array to
populate an activex control. I need to take that array and populate a
recordset (I don't care how many steps there are from array to recordset) so
I can persist the contents of the recordset to a RDBMS. I have been trying
on and off for a couple of years and I have not been able to figure it out.
Does any body have an idea?

Thanks

Dan Reber

11 Oct 2005 8:33 PM

Ralph

Show quote Hide quote

"Dan Reber" <dreber@nospam.com> wrote in message
news:eFZ1yCqzFHA.2064@TK2MSFTNGP09.phx.gbl...
> I am creating an array from multiple recordsets and use the array to
> populate an activex control. I need to take that array and populate a
> recordset (I don't care how many steps there are from array to recordset)
so
> I can persist the contents of the recordset to a RDBMS. I have been trying
> on and off for a couple of years and I have not been able to figure it
out.
> Does any body have an idea?
>
> Thanks
>
> Dan Reber
>

Need more information.
What does the array (DataTypes) look like and what tables (DDL) is the array
going to update.

[Also a bit curious why you are using an intermediate array and not updating
the control directly from the recordset/s?]

-ralph

11 Oct 2005 8:49 PM

Dan Reber

I am using arrays because I am getting data from multiple recordsets that
are aggregates of

Invoices
Payments
Rejections

or what what ever else the user selects. I am then building an array that
is a combination of fields from each recordset and "join" them accross
fields with commom values. The activex control that I use allows arrays to
be pased to it as a datasource. What I need to do now is to take that
array and convert in to a recordset because I want to use this combined data
in another control that I use that only allows recordsets as a datasource.

PS - The data is for an analytical tool and not an OLTP tool.

Thanks

Dan

Show quoteHide quote

"Ralph" <nt_consultin***@yahoo.com> wrote in message
news:bJ6dnQRvVfFOvNHeRVn-oQ@arkansas.net...
>
> "Dan Reber" <dreber@nospam.com> wrote in message
> news:eFZ1yCqzFHA.2064@TK2MSFTNGP09.phx.gbl...
>> I am creating an array from multiple recordsets and use the array to
>> populate an activex control. I need to take that array and populate a
>> recordset (I don't care how many steps there are from array to recordset)
> so
>> I can persist the contents of the recordset to a RDBMS. I have been
>> trying
>> on and off for a couple of years and I have not been able to figure it
> out.
>> Does any body have an idea?
>>
>> Thanks
>>
>> Dan Reber
>>
>
> Need more information.
> What does the array (DataTypes) look like and what tables (DDL) is the
> array
> going to update.
>
> [Also a bit curious why you are using an intermediate array and not
> updating
> the control directly from the recordset/s?]
>
> -ralph
>
>
>