New topic: Select Where Field is Nil ?
<http://forums.realsoftware.com/viewtopic.php?t=47363> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message RonBower Post subject: Select Where Field is Nil ?Posted: Thu Mar 21, 2013 2:03 pm Joined: Wed Feb 01, 2012 3:06 pm Posts: 63 My application is using a RealSQL Database to store information. There are several fields in each record and I am trying to retrieve records where a specific field is blank (or Nil). If I use a statement like: log_rs = G_Log_DB.SQLSelect( "SELECT * FROM Log_DB" ) Then I can step through each record in the set and process the record if a specific field (e.g. Log_DXCC) is blank: If log_rs.Field( "Log_DXCC" ).StringValue = "" THEN... However, I'd like to SELECT only those specific records in the SELECT Statement. Using a statement like: log_rs = G_Log_DB.SQLSelect( "SELECT * FROM Log_DB WHERE UPPER(Log_DXCC) = '' " ) returns no records. How do I format a SELECT Statement to return only those records where a specific field is Nil (or blank) ? Ron Bower Ellicott City, MD 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]
