Re: how to assign a recordset of ado to a variant?
- From: "zhangsn" <zhangsn98@xxxxxxxx>
- Date: Fri, 30 Sep 2005 06:58:46 +0800
Thank you very much.
But I think out-of-process should be yes.
"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ
:433abf62@xxxxxxxxxxxxxxxxxxxxxxxxx
> If your COM-server is in-process - yes, if out-of-process (such as Word,
> Excel) - no.
>
> V contains ADO recordset that you can use in your COM library. Look MSDN
for
> ADO recordset properties and methods. You may try also
>
> uses
> ADOInt;
>
> ADODataSet2.Recordset := v as _Recordset;
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
>
> "zhangsn" <zhangsn98@xxxxxxxx> ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅ?
> news:433a4a95@xxxxxxxxxxxxxxxxxxxxxxxxx
> > Thank you
> >
> > But if I use COM and take 'V' for parameter, then whether i can use your
> > way or not?
> > else how import the data from datasetrecord
> > into 'V' in this case????
> >
> >
> > "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ
> > :433a35c7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> >> var
> >> v: OleVariant;
> >> begin
> >> ...
> >> v := ADODataSet1.Recordset;
> >> end;
> >>
> >> or
> >> v := ADODataSet1.Recordset as IDispatch;
> >>
> >> But you can not pass recordset between processes.
> >>
> >> //------------------------------------------
> >> Regards,
> >> Vassiliev V. V.
> >> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> >> ADO.Net
> >> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> >> MS Jet (Access) and Interbase (through OLEDB)
> >>
> >>
> >> "zhangsn" <zhangsn98@xxxxxxxx> ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅ?
> >> news:4339f0d3@xxxxxxxxxxxxxxxxxxxxxxxxx
> >> > Hi
> >> > I want to pass a 'variant' to other program on another machine.
> >> > And the 'variant' should contain all data in the recordset of ado.
> >> > I see the sourcecode of delphi6. But I did not understand, and i
> >> > could not use clientdataset and provider in this .
> >> > anyone have the sample change the recordset to a variant and on the
> >> > another
> >> > program change the variant to the dataset.
> >> > rgds
> >> >
> >> >
> >>
> >>
> >
> >
>
>
.
- References:
- how to assign a recordset of ado to a variant?
- From: zhangsn
- Re: how to assign a recordset of ado to a variant?
- From: Viatcheslav V. Vassiliev
- Re: how to assign a recordset of ado to a variant?
- From: zhangsn
- Re: how to assign a recordset of ado to a variant?
- From: Viatcheslav V. Vassiliev
- how to assign a recordset of ado to a variant?
- Prev by Date: Re: MS Jet Engine 4
- Next by Date: "CommandText does not return a result set" when using "WITH" clause in Oracle
- Previous by thread: Re: how to assign a recordset of ado to a variant?
- Next by thread: Re: how to assign a recordset of ado to a variant?
- Index(es):
Relevant Pages
|