Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - SOLVED: Virtual Mode
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SOLVED: Virtual Mode

 Post Reply Post Reply
Author
Message
ElvisM View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 October 2006
Location: Venezuela
Status: Offline
Points: 129
Post Options Post Options   Thanks (0) Thanks(0)   Quote ElvisM Quote  Post ReplyReply Direct Link To This Post Topic: SOLVED: Virtual Mode
    Posted: 09 June 2008 at 11:57am
Hi friends.
 
I'm using virtual mode but I have a question...
 
If I have a query data that contains 100,000 records, I don't have any problem, but if the query retrieves me more than 100,000 records my program crash by memory capacity. I'm using arrays to populate the data in the virtual mode reportontrol.
 
Do you know a best way to work with virtual mode different to using arrays?
 
Excuseme my basic english...
 
Regards,
Elvis
Product: Xtreme SuitePro (ActiveX) version 17.2
Platform: Windows 10 64bits
Language: Visual Basic 2015
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2008 at 2:39pm
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
ElvisM View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 October 2006
Location: Venezuela
Status: Offline
Points: 129
Post Options Post Options   Thanks (0) Thanks(0)   Quote ElvisM Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2008 at 3:14pm
Hi Araron, thanks again...
I have seem your example. This is good, but only for DAO.
For instance, using  MySQL database, yo can't have AbsolutePosition property, and this feature is the base of your example...
 
I'm searching in the web for the similar property in ADO (MySQL).
 
Regards,
Elvis
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2008 at 3:20pm
Hi,
 
Seems that AbsolutePosition is supported:
 
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
Baldur View Drop Down
Senior Member
Senior Member


Joined: 22 November 2006
Location: Germany
Status: Offline
Points: 244
Post Options Post Options   Thanks (0) Thanks(0)   Quote Baldur Quote  Post ReplyReply Direct Link To This Post Posted: 07 July 2008 at 9:47am
This depends on CursorLocation.
If you use ClientSide than you have also AbsolutePosition.
 
But: the whole DataSet is than in memory !
Advantage: you can Sort the Recordset without reloading the Data from server.
 
Also it's very heavy for User's to wait until the Recordset is  filled, so you can do this with FetchAsynchron.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.203 seconds.