ADO type of cursor
Hi,
We cannot print data with a few reports when we need to use more than 30
queries. It seems that every data are loaded in the memory.
1) Could you possibly tell us the type of cursor recommended to access the
data? (CursorLocation / CursorType of the ADO objects)
2) Our problem happens only during the printing and we cannoty reproduce it
when we are using prteview mode. How report builder manages the transfer of
the data to the printer?
brgds.
We cannot print data with a few reports when we need to use more than 30
queries. It seems that every data are loaded in the memory.
1) Could you possibly tell us the type of cursor recommended to access the
data? (CursorLocation / CursorType of the ADO objects)
2) Our problem happens only during the printing and we cannoty reproduce it
when we are using prteview mode. How report builder manages the transfer of
the data to the printer?
brgds.
This discussion has been closed.
Comments
We recommend using the default cursor types given when using ADO, however we
have not thouroughly tested the use of any other types so it may be
possible.
As a test try disconnecting your event hanlders and see if that makes a
difference. If this solves the problem, then try periodically adding them
back to isolate the event hanlder with the issue.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com