can I create variable in trigger of sqlite?

Question

I want to create a update trigger,

can I create a variable betweent "BEGIN" and "END" , and set value by query from a select sql statement ?? And then execute "if" "else" statement by judging this variable

What exactly do you want to do in the trigger? – CL. Sep 09 '13 at 19:21 — CL., Sep 09 '13 at 19:21

score 3 · Answer 1 · answered Sep 09 '13 at 19:26

As an embedded database, SQLite is designed to be used directly from another programming language, so it does not have programming constructs like variables or IF statements.

If it is not possible to implement your logic with the trigger's WHEN clause or subqueries, you have to do this in Java (i.e., without a trigger).

can I create variable in trigger of sqlite?

1 Answers1