> @Simon, > > > > CASE ( SElECT BOOL FROM _TAG_EXISTS_RESULT_ ) WHEN 0 > > > > CASE takes a value. You can't put a SQLite command in there. > > > actually, it's working if you put the command between (). I guess it's > like the `` on linux (eg), > > mplayer `ls *.mp3` > > but maybe,even if it's working, you want to point that's not correct to > use it.
It is fine to use it that way. A Select inside parenthesis is a "scalar subselect". It will return a single value (in this case BOOL) from the first row returned by the select statement. It is perfectly valid.
