Codejock Developer Community : Add record from ADODB.Recordset http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 21:59:16 +0000 Sat, 14 Apr 2007 02:48:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6789 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Add record from ADODB.Recordset : Thank you jcollier I tried...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21947&title=add-record-from-adodb-recordset#21947 Author: naikosen
Subject: 6789
Posted: 14 April 2007 at 2:48am

Thank you jcollier
 
I tried a lot, but winced.
I need a complete example of it.
Correction made to the attached Project will be much appreciated.
]]> Sat, 14 Apr 2007 02:48:48 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21947&title=add-record-from-adodb-recordset#21947 <![CDATA[Add record from ADODB.Recordset : Short of writing the code for...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21797&title=add-record-from-adodb-recordset#21797 Author: jcollier
Subject: 6789
Posted: 10 April 2007 at 10:08am

Short of writing the code for you (which I don't have time to do) I'm not sure what else to tell you.  The SetVirtualMode section of the help file has pretty much everything you need except you'll replace the given values with values from the recordset the BeforeDrawRow event.

Also, the example generates 20000 random records.  You won't need to do that part either since you already have your records in the recordset.

So, I think you would do the following:

set your array variable.
Loop through the recordset, adding the values to the array
add a Template record (as it does in the help file)
reportcontrol.populate
reportControl.SetCustomDraw xtpCustomBeforeDrawRow

in BeforeDrawRow set it up to use your columns and your array variable.
]]> Tue, 10 Apr 2007 10:08:20 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21797&title=add-record-from-adodb-recordset#21797 <![CDATA[Add record from ADODB.Recordset : My database seems to grow more...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21770&title=add-record-from-adodb-recordset#21770 Author: naikosen
Subject: 6789
Posted: 09 April 2007 at 6:33pm

My database seems to grow more than 10,000,000.
Moreover, I want to learn the way to add data from a database in Virtual mode.
Guide me please.
]]> Mon, 09 Apr 2007 18:33:44 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21770&title=add-record-from-adodb-recordset#21770 <![CDATA[Add record from ADODB.Recordset : How many rows are you going to...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21758&title=add-record-from-adodb-recordset#21758 Author: jcollier
Subject: 6789
Posted: 09 April 2007 at 10:17am

How many rows are you going to have?  The data only has 93 rows which is not enough to need Virtual Mode]]> Mon, 09 Apr 2007 10:17:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21758&title=add-record-from-adodb-recordset#21758 <![CDATA[Add record from ADODB.Recordset : Help me pliz. I could not figure...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21750&title=add-record-from-adodb-recordset#21750 Author: naikosen
Subject: 6789
Posted: 07 April 2007 at 8:12pm

Help me pliz. I could not figure out how to do it.]]> Sat, 07 Apr 2007 20:12:39 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21750&title=add-record-from-adodb-recordset#21750 <![CDATA[Add record from ADODB.Recordset : I am still waiting ]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21744&title=add-record-from-adodb-recordset#21744 Author: naikosen
Subject: 6789
Posted: 06 April 2007 at 6:33pm

I am still waiting
]]> Fri, 06 Apr 2007 18:33:33 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21744&title=add-record-from-adodb-recordset#21744 <![CDATA[Add record from ADODB.Recordset : Hiya &#039;Jcollier&#039; I...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21718&title=add-record-from-adodb-recordset#21718 Author: naikosen
Subject: 6789
Posted: 05 April 2007 at 7:22pm

Hiya 'Jcollier'
 
I tried a lot to get the desired result following the online documentation, but winced.
 
It would be so kind of you to guide me with making necessary changes in the project I uploaded in this topic.
]]> Thu, 05 Apr 2007 19:22:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21718&title=add-record-from-adodb-recordset#21718 <![CDATA[Add record from ADODB.Recordset : In the Online Documentation, check...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21713&title=add-record-from-adodb-recordset#21713 Author: jcollier
Subject: 6789
Posted: 05 April 2007 at 11:50am

In the Online Documentation, check out

Private Sub wndReportControl_BeforeDrawRow

In that event, replace the data in the sample with the recordset data.

You should be able to figure it all out with the documentation and the info in this post ;)
]]> Thu, 05 Apr 2007 11:50:24 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21713&title=add-record-from-adodb-recordset#21713 <![CDATA[Add record from ADODB.Recordset : Once I had gone through the online...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21712&title=add-record-from-adodb-recordset#21712 Author: naikosen
Subject: 6789
Posted: 05 April 2007 at 11:39am

Once I had gone through the online documentation. It has just the simple instruction without adding data from a database.
 
I want to add data from a database in virtual mode. How can I do that?
]]> Thu, 05 Apr 2007 11:39:57 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21712&title=add-record-from-adodb-recordset#21712 <![CDATA[Add record from ADODB.Recordset : The Online Documentation has step...]]> http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21711&title=add-record-from-adodb-recordset#21711 Author: jcollier
Subject: 6789
Posted: 05 April 2007 at 11:18am

The Online Documentation has step by step instructions and an example.  Just go to the help file and search for SetVirtualMode]]> Thu, 05 Apr 2007 11:18:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=6789&PID=21711&title=add-record-from-adodb-recordset#21711