Codejock Developer Community : SOLVED: 100000 records or more!

Codejock Developer Community : SOLVED: 100000 records or more! http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 23:36:25 +0000 Thu, 20 Nov 2008 04:24:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=10814 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[SOLVED: 100000 records or more! : "Hi Baldur, of course you...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=43009&title=solved-100000-records-or-more#43009 Author: ruffneck9876
Subject: 10814
Posted: 20 November 2008 at 4:24am

"Hi Baldur,

of course you are right, but did you ever try to capture a DblClick in the group area? Long time ago I offered my users to doubleclick in the group area to collapse (or expand) all groups at a time - using the Janus grid with builtin DblClick event. No I want to switch to CJs ReportControl and certainly I do not want to degrade functionality because of ReportControl limitations. "

have you tried the activebar feature? using the active bar i can use the right mouse click to open a menu where i can select if i want to expand collapse or even see a print preview or generate HTML.

this can be activated on a groupcaption, header and if u just click anywhere in your form all depends on your settings.

activebar21 really helped me out look it up :P

]]> Thu, 20 Nov 2008 04:24:16 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=43009&title=solved-100000-records-or-more#43009 <![CDATA[SOLVED: 100000 records or more! : First. Thank you ALL.After some...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=38117&title=solved-100000-records-or-more#38117 Author: Source
Subject: 10814
Posted: 10 July 2008 at 7:07am

First. Thank you ALL.

After some consideration and tests (even tried with Janus Grid and TGrid) I will stick with CJ report control; always my first choice

My current application will use previous example with Peter59 LoadFromDatabase4 example with getrows(100) option.
193.000 records in 6 seconds.

Since this amount of records will only be used on 3 of 23+ or more tables I will (for now) stay with this option - until CJ guys implement some "direct access to database".

Grouping and filter on all records (filtertext) are ok - see Peter59 example and use filtertext option on a label for example.

Preview/Print as usual.

RowDblclick to edit the record on a subform with navigation buttons (previous,next,first,last) and new,save,cancel ones also.

Prevent RowDblclick on group header row - see CJ outlook2003 example (exapand or collapse the group).

So. I think this is ok for me right for now.

Regards.

Carlos Neves

]]> Thu, 10 Jul 2008 07:07:15 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=38117&title=solved-100000-records-or-more#38117 <![CDATA[SOLVED: 100000 records or more! : Baldur wrote:For DoubleClick...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=38091&title=solved-100000-records-or-more#38091 Author: Peter59
Subject: 10814
Posted: 10 July 2008 at 3:30am

Baldur wrote:

For DoubleClick you can use RowDblClick-Event.

Hi Baldur,

of course you are right, but did you ever try to capture a DblClick in the group area? Long time ago I offered my users to doubleclick in the group area to collapse (or expand) all groups at a time - using the Janus grid with builtin DblClick event. No I want to switch to CJs ReportControl and certainly I do not want to degrade functionality because of ReportControl limitations.

]]> Thu, 10 Jul 2008 03:30:18 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=38091&title=solved-100000-records-or-more#38091 <![CDATA[SOLVED: 100000 records or more! : For DoubleClick you can use RowDblClick-Event....]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=37894&title=solved-100000-records-or-more#37894 Author: Baldur
Subject: 10814
Posted: 07 July 2008 at 9:55am

For DoubleClick you can use RowDblClick-Event.]]> Mon, 07 Jul 2008 09:55:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=37894&title=solved-100000-records-or-more#37894 <![CDATA[SOLVED: 100000 records or more! : Peter59 wrote:Hi, if speed...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36512&title=solved-100000-records-or-more#36512 Author: Aaron
Subject: 10814
Posted: 10 June 2008 at 1:25pm

Peter59 wrote:

Hi,

if speed has first priority you can look at the attached sample: I added two new options. The first one ("Load from database 3") with ADO and the GetRows() method, the other uses the same method but with DAO ("Load from database 4").

Product: Xtreme SuitePro (ActiveX) version 11.2.2/12.0
Platform: Windows 2K/XP/Vista (32bit)
Language: Visual Basic 6.0 SP6

Peter,

Can you make a list of what is possible with your sample project? Like I did... This way you know what to expect from a sample

(ps you can edit your previous post with sample project)

Thanks

]]> Tue, 10 Jun 2008 13:25:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36512&title=solved-100000-records-or-more#36512 <![CDATA[SOLVED: 100000 records or more! : Of course, the GetRows method...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36503&title=solved-100000-records-or-more#36503 Author: Peter59
Subject: 10814
Posted: 10 June 2008 at 11:44am

Of course, the GetRows method needs a lot of memory, but under certain conditions ("if speed has first priority") or when recordcount is known within a range, it could be an alternative. Furthermore you can limit the need of memory by using the optional parameters of the GetRows method, such as 100 records at a time: varData = rs.GetRows(1000).

At least a good example for showing another way of populating ReportControl.

Peter

]]> Tue, 10 Jun 2008 11:44:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36503&title=solved-100000-records-or-more#36503 <![CDATA[SOLVED: 100000 records or more! : The problem with this method (getrows...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36502&title=solved-100000-records-or-more#36502 Author: ElvisM
Subject: 10814
Posted: 10 June 2008 at 11:25am

The problem with this method (getrows - variant arrays) is the limit in the phisical memory. If the recordset has a lot of records with many columns... the program could crash.

]]> Tue, 10 Jun 2008 11:25:36 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36502&title=solved-100000-records-or-more#36502 <![CDATA[SOLVED: 100000 records or more! : Hi, if speed has first priority...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36501&title=solved-100000-records-or-more#36501 Author: Peter59
Subject: 10814
Posted: 10 June 2008 at 11:17am

Hi,

I'm disappointed too that there is no DblClick() event for the ReportControl, but I needed it urgent, so I subclassed the ReportControl with the famous ssubtmr6.dll from vbAccelerator. Take a look in the attached files.

In addition to Aarons sample, I added the following options/features:

The button "Load from database 3" uses ADO to connect to thedatabase and instead of iterating through the recordset with methodMoveNext it uses GetRows to retrieve all records at a time and storesit in a two dimensional variant array. It depends on the count ofrecords how much memory is used.
The button "Load from database 4" uses DAO to connect to thedatabase and uses the GetRows method too, but not all records at a timebut rather 1000 records after another
The Caption of a grouprow is extended by some information using the BeforeDrawRow event (see screenshot above)
To capture ReportControl DblClick events I use a subclassing method provided by vbAccelerator

Please keep in mind that I'm pretty new with the ReportControl, so any suggestion is welcome.

Best regards, Peter

Product: Xtreme SuitePro (ActiveX) version 11.2.2/12.0
Platform: Windows 2K/XP/Vista (32bit)
Language: Visual Basic 6.0 SP6
]]> Tue, 10 Jun 2008 11:17:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36501&title=solved-100000-records-or-more#36501 <![CDATA[SOLVED: 100000 records or more! : Sorry, bad zip (forget to remove...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36182&title=solved-100000-records-or-more#36182 Author: Source
Subject: 10814
Posted: 03 June 2008 at 4:44am

Sorry, bad zip (forget to remove some references).

Here it is corrected uploads/20080603_044350_PFact.zip

Thanks.

Carlos

]]> Tue, 03 Jun 2008 04:44:47 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36182&title=solved-100000-records-or-more#36182 <![CDATA[SOLVED: 100000 records or more! : Hi, Maybe this is what you...]]> http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36121&title=solved-100000-records-or-more#36121 Author: Aaron
Subject: 10814
Posted: 02 June 2008 at 7:29am

Hi,

Maybe this is what you are looking for. It will be much faster since you are "connected" to the table in the database. All operations will be done on the recordset itself. I managed to make a sample project that will populate the ReportControl in virtual mode and allows you to:

Sort columns with filter
Inplace editing on subitems (which are directly updated in the database table)
Get properties of selected record of database table
Access database directly
Tip: you can change the SQLString as you wish (now it's in the code but you could "build" your own sql string if necessary)

Note, if you are going to test this, add a Field in your own database with the name: AutoNumber and set datatype to autonumber(this way you can see the sorting)

It looks like databinding, it's not finished yet but it's a start

Check it out yourself, maybe I gave you a jumpstart with this.

BTW, I tried to open your project but it gave a lot of errors.

But, maybe I don't need to open your project...

uploads/20080602_072905_ReportVirtualDa.zip

]]> Mon, 02 Jun 2008 07:29:54 +0000 http://forum.codejock.com/forum_posts.asp?TID=10814&PID=36121&title=solved-100000-records-or-more#36121