Hi, I am migrating my PC software to android system. However, it gives syntax error when executing if statement? Does ultralite support if-statement in query? or is there any equivalent to it? Thanks |
Ultralite does not support any procedural language including stored procedures or functions or triggers, so there is no support for, nor need of, if statements. But if you are wanting to use an "if" within an expression then, yes, Ultralite supports if expressions. The basic syntax of an if expression is: IF search-condition THEN expression1 [ ELSE expression2 ] ENDIF Example: select IF @foo = @bar THEN 1 ELSE 0 ENDIF as X from T See the documentation for more information. Thank you!
(29 May '13, 09:15)
Peng84
Replies hidden
If that answer has helped you, you're invited to mark it as accepted - cf. How do I accept an answer to my question?
(29 May '13, 09:21)
Volker Barth
|