New topic: I need a method...
<http://forums.realsoftware.com/viewtopic.php?t=47123> Page 1 of 1 [ 6 posts ] Previous topic | Next topic Author Message BrianOBrien Post subject: I need a method...Posted: Fri Mar 01, 2013 5:03 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 659 Location: University Of Calgary, Faculty Of Medicine Private Function Concatenate(rSets() as RecordSet) As RecordSet End Function I have a bunch of record sets that have identical structure but I need to concatenate them together so as to have on record set. It has been suggested that I create a real database to do this.. help? _________________ If at first you don't succeed... Try REALBasic. Top JohnV Post subject: Re: I need a method...Posted: Fri Mar 01, 2013 5:44 pm Joined: Sun Jan 28, 2007 2:38 pm Posts: 187 Try: SELECT * INTO NewTable FROM OldTable WHERE 1=0 Top BrianOBrien Post subject: Re: I need a method...Posted: Fri Mar 01, 2013 6:15 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 659 Location: University Of Calgary, Faculty Of Medicine JohnV wrote:Try: SELECT * INTO NewTable FROM OldTable WHERE 1=0 What table? Where are you refrencing the record set array? _________________ If at first you don't succeed... Try REALBasic. Top Sky Stream Post subject: Re: I need a method...Posted: Fri Mar 01, 2013 6:22 pm Joined: Sun Nov 23, 2008 12:27 am Posts: 392 Location: New Jersey BrianOBrien wrote:Private Function Concatenate(rSets() as RecordSet) As RecordSet End Function I have a bunch of record sets that have identical structure but I need to concatenate them together so as to have on record set. It has been suggested that I create a real database to do this.. help? can you provide some examples as to how the data is stored, what it looks like, and desired results? _________________ - Rich Top BrianOBrien Post subject: Re: I need a method...Posted: Fri Mar 01, 2013 7:12 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 659 Location: University Of Calgary, Faculty Of Medicine Psuedo codedim bigRS as RecordSet for i=0 to rSets.Ubound while not rSets(i).eof bigRs.AddRecord rSets(i).record rSets(i).nextRecord wend next return bigRS _________________ If at first you don't succeed... Try REALBasic. Top timhare Post subject: Re: I need a method...Posted: Fri Mar 01, 2013 7:25 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 12089 Location: Portland, OR USA You cannot create a recordset like that. You should create your own data class and create an array of records. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 6 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
