Network traffic when accessing RecNo in TADOQuery

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

Article #290

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

#290

From: Tino Uhlig
Date: Fri, 16 Jun 2006 10:28

17 lines
1714 bytes

Hello,

I have a somewhat strange behaviour with one TADOQuery in one application 
that I do not understand. Maybe someone could clarify this for me:

As I said: I have a TADOQuery that uses a serverside cursor with ctKeyset. 
When I read the RecNo property of that Query, I found that the active 
dataset is read from the server agein. If I use a cachesize greater than 1 
then the whole cache is re-read. I am wondering why this happens so I 
created a new project with a similar Query, also with a serverside cursur 
and ctKeyset cursortype and there I can access RecNo without any access to 
the server. Why is that? Does anybody know in which cases the buffer will be 
re-read when accessing RecNo?

Thanks,

Tino

Technical Details

Message-ID: <449287ce@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,97a8ed57e999f2dd,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Tino Uhlig" <t.uhlig@conworx.com>
From: "Tino Uhlig" <tino_uhlig@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Network traffic when accessing RecNo in TADOQuery
Date: Fri, 16 Jun 2006 12:28:30 +0200
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 84.189.241.108
Message-ID: <449287ce@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1150453710 84.189.241.108 (16 Jun 2006 03:28:30 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail