🚀 go-pugleaf

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:42789e2f$1@newsgroups.borland.com...
> Use recordset Fields collection, it has operator [] or GetItem() method.

I did manage to get it going using the following

            wstUser =
adoRS->Fields->get_Item(Variant(1))->get_Value().bstrVal;

However I was unable to get the [] operator working. Also the get_Item works
only on the field position, not the name. I expected to be able to go
something like

            wstUser = adoRS->Fields["User"]->Value().bstrVal;

Am I missing something here?

Also I could not access a GetItem method (as suggested in some ADO Recordset
documentation) but had to use get_Item instead.

> ADODataSet has property Recordset that you can use, it takes
> System::DelphiInterface< _Recordset >.

Thanks, I've got that to work.

Could you please tell me if the following code is correct. I especially
wondered if I need to dispose of the Recordset originally created with the
TADODataSet - or does that not exist until the Dataset is actually
populated?

    (Adodb_tlb::Recordset15*)ado = RxWClient->GetEmailAddresses(&ClientID);

    TADODataSet* ds = new TADODataSet(this);

    ds->Recordset = (Adoint::Recordset*)ado;

    ShowMessage(ds->FieldByName("Phone Number")->AsString);

    delete ds;

    ado->Close();

Cheers
Bas