Re: Recordset1 to Recordset2

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

Article #706

Back to borland.public.cppbuilder.database.ado Previous Next

#706

From: Igor Tsukanov
Date: Thu, 21 Jul 2005 05:54

26 lines
1984 bytes

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote:
>Manually - there are few lines of code to traverse recordset and assign all 
>columns. Or, better, use INSERT INTO or SELECT INTO command.
>
>//------------------------------------------
>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)
>
>
>"Igor Tsukanov" <darl@office.pib.com.ua> �������/�������� � �������� 
>���������: news:42de5f2c$1@newsgroups.borland.com...
>>
>> How can I transfer(append all) the data from one recordset to other 
>> recordset per saltum? In my case I have one recordset with connection to 
>> Text-file, second - DBase-file. The both providers is MS Jet.
>>
>> Best regards 
>
>

The either recordset connected to own connection(ADOQuery1 connected to ADOConnection1, ADOQuery2 to ADOConnection2 and because of I don't use the select/insert etc.).

Technical Details

Message-ID: <42df388d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <42de5f2c$1@newsgroups.borland.com> <42dea75a$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,7dfae1f000c4ab63
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Igor Tsukanov" <darl@office.pib.com.ua>
Sender: "Igor Tsukanov" <darl@office.pib.com.ua>
Reply-To: "Igor Tsukanov" <darl@office.pib.com.ua>
Subject: Re: Recordset1 to Recordset2
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 83.137.88.5     
X-Forwarded-For: 192.168.107.72
References: <42de5f2c$1@newsgroups.borland.com> <42dea75a$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <42df388d$1@newsgroups.borland.com>
Date: 20 Jul 2005 22:54:21 -0700
X-Trace: newsgroups.borland.com 1121925261 207.105.83.66 (20 Jul 2005 22:54:21 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message