ADO. Delphi _Recordset

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Dmitry Konnov Wed, 21 Sep 2005 17:33

#592

Author: Dmitry Konnov
Date: Wed, 21 Sep 2005 17:33

20 lines
1326 bytes

Hello,

I want to transport Recordset of ADO components over TCP/IP as Variant

Everything goes well if i try  save TADOQuery.Recordset in Variant variable:
var
a_Variant : Variant;
begin
  a_Variant := Query1.Recordset;
end;

But if i try to assign Variant back to Recordset

 Query2.Recordset := a_Variant;

i get error - can not assign Variant to _Recordset

Please help.

Dmitry Konnov

Re: ADO. Delphi _Recordset

#598

Author: Mark Guerrieri
Date: Mon, 03 Oct 2005 16:09

32 lines
1765 bytes

1- Save the Recordset to XML
2- Transport the XML over TCP/IP
3- Create anew Recordset object at the remote end
4- Load the XML into the new recordset object

Mark

"Dmitry Konnov" <dmitry@weblinedesign.biz> wrote in message
news:4331999f@newsgroups.borland.com...
> Hello,
>
> I want to transport Recordset of ADO components over TCP/IP as Variant
>
> Everything goes well if i try  save TADOQuery.Recordset in Variant
variable:
> var
> a_Variant : Variant;
> begin
>   a_Variant := Query1.Recordset;
> end;
>
> But if i try to assign Variant back to Recordset
>
>  Query2.Recordset := a_Variant;
>
> i get error - can not assign Variant to _Recordset
>
> Please help.
>
> Dmitry Konnov
>
>

Re: ADO. Delphi _Recordset

#610

Author: Dmitry Konnov
Date: Sun, 16 Oct 2005 09:35

12 lines
1369 bytes

Hi Mark,

> 1- Save the Recordset to XML
> 2- Transport the XML over TCP/IP
> 3- Create anew Recordset object at the remote end
> 4- Load the XML into the new recordset object

Sounds not very good.
If Recordset could be possible to save to stream but not to file.
I think that will extremely slow down system to exchange Datasets via file.

Dmitry

Re: ADO. Delphi _Recordset

#613

Author: Mark Guerrieri
Date: Tue, 18 Oct 2005 15:02

25 lines
1778 bytes

Yes, it can be saved to a stream.  I routinely save recordsets to
TStringStream instances and transport the resulting XML to a remote process
via a method parameter, where it is loaded back in to a new Recordset
object.

Mark

"Dmitry Konnov" <dmitry@weblinedesign.biz> wrote in message
news:43521ed9$1@newsgroups.borland.com...
> Hi Mark,
>
> > 1- Save the Recordset to XML
> > 2- Transport the XML over TCP/IP
> > 3- Create anew Recordset object at the remote end
> > 4- Load the XML into the new recordset object
>
> Sounds not very good.
> If Recordset could be possible to save to stream but not to file.
> I think that will extremely slow down system to exchange Datasets via
file.
>
> Dmitry
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads