🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How to Convert TDataSet to TADO Recordset

#101
From: Vassiliev V. V.
Date: Thu, 23 Aug 2007 19:21
66 lines
3962 bytes
Intent was really to persuade you to not continue in this direction. Did 
Crystal Reports stopped support BDE? If not, you could connect to BDE tables 
directly, without datasets. Or connect to DBF/Paradox files with Jet OLEDB 
provider (there may be problems with update Paradox tables, but in read-only 
mode this may work).

If you still want to continue with creating recordset wrapper for TDataSet 
(in this case through special OLEDB provider), look at:

http://www.dataweb.de/en/support/articles/ospdelphi/ospdelphi.html

http://msdn2.microsoft.com/en-us/library/aa160399(office.11).aspx

However it could take much more time and efforts than you expect.

//------------------------------------------
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)



"Sinead Bunyan" <nospamSBUNYAN@DAIRYMASTER.COM> ???????/???????? ? ???????? 
?????????: news:46cdbe15@newsgroups.borland.com...
> Hi Clayton,
>
> I am basically incorporating Crystal Reports 11 into an existing c++ 
> project. Previously we had used a component from a company called 
> Suprasoft, which allowed us to pass a TDataSet to report templates and 
> using TTX files we could display our reports accordingly. In this way we 
> did not have to specify the data location when designing the reports.
>
> However (!), we now are faced with using Crystal Reports 11, which 
> requires that data be passed to the reports as an ADO recordset. Because 
> it is an existing project, all datasets are created and ideally we would 
> like a way to work from the existing datasets - we do not want to change 
> all TDataSet components to TADODataSets and also we do not want to have to 
> generate these datasets twice (once to populate our TDataSet, and once to 
> populate a TADODataSet). Hopefully this is making sense?
>
> Any suggestions would be greatly appreciated - I have a very limited 
> knowledge of ADO objects, sorry for my ignorance on this subject!
>
> Thanks in advance,
> Sinead
>
>
> "Clayton Arends" <nospam_claytonarends@hotmail.com> wrote in message 
> news:46cdb750$1@newsgroups.borland.com...
>>> Thank you for your help on this, at least now I know that it is possible 
>>> and can work from there.
>>
>> I believe the intent was to persuade you to not continue in this 
>> direction.
>>
>> Perhaps you can explain a little about the types of 'Rpt' and 'Database' 
>> and what functionality you are after.  There might be other alternatives 
>> that you can pursue once a little more is known about your problem.
>>
>> - Clayton
>>
>>
> 
Technical Details
Message-ID: <46cdde35@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <46cd6ffd@newsgroups.borland.com> <46cd9901@newsgroups.borland.com> <46cdb544$1@newsgroups.borland.com> <46cdb750$1@newsgroups.borland.com> <46cdbe15@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,629b3b97691ea625
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vassiliev V. V." <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <46cd6ffd@newsgroups.borland.com> <46cd9901@newsgroups.borland.com> <46cdb544$1@newsgroups.borland.com> <46cdb750$1@newsgroups.borland.com> <46cdbe15@newsgroups.borland.com>
Subject: Re: How to Convert TDataSet to TADO Recordset
Date: Thu, 23 Aug 2007 23:21:04 +0400
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-Antivirus: avast! (VPS 000768-0, 23.08.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 85.93.138.132
Message-ID: <46cdde35@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1187896885 85.93.138.132 (23 Aug 2007 12:21:25 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail