PDA

View Full Version : Checking if a SQLite float is null?




Buschmaster
Jan 20, 2009, 11:12 PM
There are two routes I could take here... Set the default value to some random float that I know will never be used or figure out how to actually figure out a null value.


I am grabbing information from my SQLite DB and it has several fields, almost all of which can be null. If it's not null, I don't put anything into the NSDictionary I'm creating for it, but as of right now I have no idea how to figure that out... I'm struggling with this, why can't it be as easy as PHP is? ;)

Any help is much appreciated!



HardyMacia
Mar 10, 2009, 10:36 AM
Use ISNULL

select * from mytable where myfloat ISNULL