New topic: SQL Question
<http://forums.realsoftware.com/viewtopic.php?t=47453> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message plunkettphoto Post subject: SQL QuestionPosted: Sat Mar 30, 2013 8:24 pm Joined: Fri Oct 10, 2008 7:14 pm Posts: 69 I have a RecordSet that I want to move to particular row based on the key value. The select would be "SELECT * from Contacts where pkContactID = " + iContactID Problem is I don't want to execute a new select and create a new RecordSet, I want to move to the row in existing record set. Instead of .MoveNext or .MovePrevious I want to .MoveTo... How would I do this? thanks much in advance, bill Top timhare Post subject: Re: SQL QuestionPosted: Sun Mar 31, 2013 1:31 am Joined: Fri Jan 06, 2006 3:21 pm Posts: 12186 Location: Portland, OR USA Copy the data from each row of the recordset into some other data structure, such as a class you create just for this purpose. Instantiate a new object for each row, load it, and store it in a Dictionary keyed by ID. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 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]
