SQlite Trigger Execution Problem

Question

I'm new to Android & SQlite. I was trying to create the following trigger on an SQLite database in Android.

final String CREATE_TRIGGER_STATES = 
            "CREATE TRIGGER fk_insert_state BEFORE "
            + "INSERT on tbl_states"
            + "FOR EACH ROW "
            + "BEGIN "
            + "SELECT RAISE(ROLLBACK, 'insert on table "
            + "\"tbl_states\" violates foreign key constraint "
            + "\"fk_insert_state\"') WHERE (SELECT id FROM "
            + "tbl_countries WHERE id = NEW.country_id) IS NULL; "
            + "END;";
        db.execSQL(CREATE_TRIGGER_STATES);

Error log:

android.database.sqlite.SQLiteException: near "EACH": syntax error: CREATE TRIGGER fk_insert_state BEFORE INSERT on tbl_statesFOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'insert on table "tbl_states" violates foreign key constraint "fk_insert_state"') WHERE (SELECT id FROM tbl_countries WHERE id = NEW.country_id) IS NULL; END;

Is there a problem with the syntax ?

mu is too short · Accepted Answer · 2011-06-13 06:23:54Z

2

I'm guessing that the relevant portion of the error message is right here:

... on tbl_statesFOR EACH ROW ...
//--------------^^

You're missing a space after tbl_states:

final String CREATE_TRIGGER_STATES = 
            "CREATE TRIGGER fk_insert_state BEFORE "
            + "INSERT on tbl_states " // Missing space added
            //... Continue on as before.

answered Jun 13, 2011 at 6:23

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

thumbmunkeys · Accepted Answer · 2011-06-13 06:25:12Z

1

You forgot a space:

 + "INSERT on tbl_states "    // Space missing here
 + "FOR EACH ROW "

answered Jun 13, 2011 at 6:25

thumbmunkeys

20.8k8 gold badges70 silver badges111 bronze badges

Collectives™ on Stack Overflow

SQlite Trigger Execution Problem

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related