Android Question [SOLVED] Sqlite error on function iif

incendio

Well-Known Member
Licensed User
Longtime User
Hi guys,

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.
 

DonManfred

Expert
Licensed User
Longtime User
Which Version of the SQL-engine is running on the device?
IIF is supported since 3.32.

 
Upvote 1

incendio

Well-Known Member
Licensed User
Longtime User
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.

Will try to find other solution for this problem.
 
Last edited:
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…