New topic: getting record count
<http://forums.realsoftware.com/viewtopic.php?t=43788> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Larry6295 Post subject: getting record countPosted: Fri Apr 27, 2012 3:00 pm Joined: Thu Feb 23, 2012 7:16 pm Posts: 52 Location: Springfield, Illinois I tried to post this earlier and I think I failed to submit it. If there are 2 of these, I apologize. I have tried various combinations to get a count of all records selected. It seems I have been able to get the count OR all the records but not both. Below I am trying to get all selected records and a count. I tried "cnt".integervalue also ("cnt").integervalue also cnt.integervalue I also tried rs.recordcount Any advice is always appreciated. dim cnt as integer dim sql as string sql = "SELECT count * as cnt FROM Names " +_ " order by Lastname, Firstname" '---------------------------------------- ' ' Now we select the records from the database and add them to the list. dim rs as recordSet ' rs = app.NamefileDB.sqlSelect(sql ) populateListBox NamesList, rs namefile.totnames.text = "cnt".integervalue rs.close _________________ Larry6295 Professional 2011 R4.3 Windows 7 64 bit HP 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]
