Article View: borland.public.cppbuilder.database.ado
Article #2014Re: TADOQuery and eoASyncFetch problem
From: Vic
Date: Thu, 11 Dec 2003 13:11
Date: Thu, 11 Dec 2003 13:11
49 lines
2755 bytes
2755 bytes
Thanks Vassiliev for your replies, but the BetterADODataset component
neither works. It try it in delphi, and gives me the same problem.
This is what I do ( in delphi )
procedure TForm1.Button1Click(Sender: TObject);
begin
BetterADODataSet1.Open;
end;
procedure TForm1.BetterADODataSet1FetchComplete(DataSet: TCustomADODataSet;
const Error: Error; var EventStatus: TEventStatus);
var
ListItem: TListItem;
begin
DataSet.First;
with ListView1 do
begin
while ( DataSet.Eof = false ) do
begin
ListItem := Items.Add;
ListItem.Caption := DataSet.FieldValues['TEXTO1'];
ListITem.SubItems.Add(DataSet.FieldValues['TEXTO2']);
DataSet.Next;
end;
end;
Label1.Caption := 'Dataset '+ IntToStr(Dataset.RecordCount) + ' Items ' +
IntToStr(ListView1.Items.Count);
end;
The result is the same : Dataset 5000 Items 4999
I see that if I put CacheSize to 20, the result is 'Dataset 5000 Items
4980'. I think that the problem is in the CacheSize property. How can I put
the CacheSize to 0 ?? , or where are the rows that are loaded in the cache ?
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> escribi๏ฟฝ en el mensaje
news:3fd85c21$1@newsgroups.borland.com...
> That is difficult to say why it happens but you may try to install
> BetterADODataSet from http://web.orbitel.bg/vassil/. It has no BCB version
> but I do not think there will be problems installing it.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
Technical Details
Message-ID:
<3fd86d01@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3fd76a28@newsgroups.borland.com> <3fd80f4e@newsgroups.borland.com> <3fd82a7b@newsgroups.borland.com> <3fd85c21$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,361a11b4c91b34f X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-12-11 05:39:33 PST Reply-To: "Vic" <Victor@espainformatica.com> From: "Vic" <victor@espainformatica.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3fd76a28@newsgroups.borland.com> <3fd80f4e@newsgroups.borland.com> <3fd82a7b@newsgroups.borland.com> <3fd85c21$1@newsgroups.borland.com> Subject: Re: TADOQuery and eoASyncFetch problem Date: Thu, 11 Dec 2003 14:11:44 +0100 Lines: 51 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 80.24.136.172 Message-ID: <3fd86d01@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1071148289 80.24.136.172 (11 Dec 2003 05:11:29 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail