New topic: mySQL looping thru Records
<http://forums.realsoftware.com/viewtopic.php?t=47299> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message JohnV Post subject: mySQL looping thru RecordsPosted: Fri Mar 15, 2013 4:50 pm Joined: Sun Jan 28, 2007 2:38 pm Posts: 201 I am trying to loop thru a record set and make changes to each record. I successfully get three records. I can only get the code to commit the changes to the first record. What am I failing to do? rs=DB.sqlSelect(stmt) //Got 3 records while not rs.eof rs.edit rs.field("Foo").StringValue="Bar" rs.field("note").StringValue="Append top of note"+endofline+rs.field("note").StringValue rs.update rs.MoveNext wend I have stripped the error handling out for simplicity in this post. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- 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]
