vendredi 25 décembre 2015

Browse results select in trigger sqlite

If in android I use transaction to insert more record to sqlite then the NEW table in trigger insert has more row? If it's true. I want to create a instead of trigger in sqlite, in the trigger I use a select query to compare NEW and a table(in the select result has a field A). The field A has 3 values. I need to check field A to insert into another table. So I need to browse the result to check field A. How can I do that?

Aucun commentaire:

Enregistrer un commentaire