New topic: Stepping through records in db
<http://forums.realsoftware.com/viewtopic.php?t=31402> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message dudleyH Post subject: Stepping through records in dbPosted: Thu Dec 03, 2009 9:03 am Joined: Wed Oct 14, 2009 7:41 pm Posts: 20 I have searched, could someone point me to a simple method of stepping through a group of records in a table. Not the built in controls, but custom coded. I would like custom controls to move back and forth through the table. The records are constantly being added and deleted with autoincrement therefore I have no idea what the id of the first record is or the last, otherwise it would be simple. Probably is and I'm to dense to see it. thanks Top kendoll Post subject: Re: Stepping through records in dbPosted: Thu Dec 03, 2009 7:01 pm Joined: Mon Jul 17, 2006 10:39 am Posts: 1542 Assuming you have a reference to your database, you use its SQLSelect to query your database for the data you need (which can be all of it, e.g. "SELECT * FROM table"). This returns a RecordSet which has MoveFirst, MovePrevious, MoveNext, And MoveLast methods that you can use to navigate through the rows returned by your select statement. _________________ Kenneth McCleary [email protected] 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]
