On 12/13/2011 6:04 PM, Grace Batumbya wrote:
Hey guys,
Since SQLite does not support stored procedures, what are some
workarounds that are used to accomplish things like executing a
statement based on a conditional.
For example.
IF value OF column IN tableX == 'foo'
DO statement 1
ELSE statement 2
Depends on the exact nature of statements 1 and 2. Sometimes the whole
construct can be combined into a single statement. Other times, the
logic will have to be written in application code. Triggers also can be
used as poor man's stored procedures.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
