Devart Forums

hi dears.
why does not work 'IF' keyword in SQLite Queries on TUniQuery!?

Hello.

There is no IF-THEN-ELSE implementation in SQLite.
You should use the CASE expression instead of IF.
You can find more information about the CASE expression in the official SQLite documentation here: http://www.sqlite.org/lang_expr.html#case

thanx!
it is worked...
but in some applications such as SQLite2009 Pro, in query statements "IF" keyword does work!

The point is that SQLite2009 Pro uses a specially built SQLite client library with many additional features provided. The official version of the client library that is available on the SQLite site, doesn't provide such functionality.