New topic: ODBCDatabase empty field selection problem.
<http://forums.realsoftware.com/viewtopic.php?t=47227> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message tadicboris Post subject: ODBCDatabase empty field selection problem.Posted: Sat Mar 09, 2013 4:05 am Joined: Fri Nov 25, 2011 3:14 am Posts: 22 Location: Serbia I am using access file (mdb) created in Access and I am trying to extract rows where particular field is empty: dim rec as recordset rec = odbcdb.sqlselect("Select * from kartoteka where [HP dijagnoza] = ''") and got no result ??? . but where I try dim rec as recordset rec = odbcdb.sqlselect("Select * from kartoteka where [HP dijagnoza] <> ''") I got right results.. It seems that odbc database cant find empty fields or I am doing something wrong?? _________________ Dr Boris TadiÄ Medical Software Development www.digitsoft.rs 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]
