hi dears.
why does not work 'IF' keyword in SQLite Queries on TUniQuery!?
no such function: if in SQLite
Re: no such function: if in SQLite
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
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
-
mohsen24000
- Posts: 2
- Joined: Thu 09 Jun 2011 10:48
Re: no such function: if in SQLite
thanx!
it is worked...
but in some applications such as SQLite2009 Pro, in query statements "IF" keyword does work!
it is worked...
but in some applications such as SQLite2009 Pro, in query statements "IF" keyword does work!
Re: no such function: if in SQLite
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.