Have an old application that was runs OK, but now got an error when compiled.
This is the error message :
android.database.sqlite.SQLiteException: no such function: iif (code 1): , while compiling: select ID,BRCD,iif(sz <> '00', ART||' '||CLR||' '||SZ,ART) ART,PRC from m_art where unt in ('PCS') and id <> 0 order by ART,CLR,SZ
Is that a wrong select statement? I ran it via other database manager and it ran OK.
Thanks for you info, don't know what sqlite version running on the device, device is at users, but definitely not ver 3.32, since this app used long time ago. Recently, just added iif function where error occurred.