Network traffic when accessing RecNo in TADOQuery

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

1 messages

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

1 total messages Started by Tino Uhlig Fri, 16 Jun 2006 10:28

#290

Author: 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

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