Report Control - SOLVED: Virtual Mode

Print Page | Close Window

SOLVED: Virtual Mode

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=10966
Printed Date: 20 September 2024 at 10:30am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: SOLVED: Virtual Mode

Posted By: ElvisM
Subject: SOLVED: Virtual Mode
Date 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

Replies:

Posted By: Aaron
Date Posted: 09 June 2008 at 2:39pm

Hi,

See:

http://forum.codejock.com/forum_posts.asp?TID=10814 - http://forum.codejock.com/forum_posts.asp?TID=10814

-------------
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....

Posted By: ElvisM
Date 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

Posted By: Aaron
Date Posted: 10 June 2008 at 3:20pm

Hi,

Seems that AbsolutePosition is supported:

http://iasp.mediahost.org/docs/support/mysql.html - http://iasp.mediahost.org/docs/support/mysql.html

-------------
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....

Posted By: Baldur
Date 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.