Android Question [SOLVED] Sqlite error on function iif

[incendio]

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]

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

An Essential Guide to the SQLite IIF() Function

In this tutorial, you will learn about the SQLite IIF() function that allows you to add the if-else logic to queries.

www.sqlitetutorial.net

 

[DonManfred]

What does

select sqlite_version();

return if you use this SQL-Query with your Database? On your Device. Not on your PC...

 

[incendio]

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.