New topic: A Question about RecordSet
<http://forums.realsoftware.com/viewtopic.php?t=47545> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message BrianOBrien Post subject: A Question about RecordSetPosted: Mon Apr 08, 2013 1:10 pm Joined: Wed Jul 07, 2010 2:55 pm Posts: 669 Location: University Of Calgary, Faculty Of Medicine I do an SQL query and my record set returned is not NULL but there are no records in the record set. I can access the record set but there is nothing in it. myRS = dc.SQLSelect(sql) if dc.Error or myRS = nil then fileLocs.Append("Unknown") else fl = myRS.IdxField(1).StringValue if fl = "" then fileLocs.Append("Unknow") // This is where my code reaches... ???? else fileLocs.Append (fl) end if end if Is there a way to know that 0 records were returned? _________________ If at first you don't succeed... Try REALBasic. 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]
