how to drop trigger of sqlite in Android

Asked Aug 20 '13 at 07:04

Active Aug 20 '13 at 07:04

Viewed 904 times

String  sql1 = "DROP TRIGGER IF EXISTS Trigger_Insert_"  + table  +  " ;"  ;       
db.execSQL(sql1);


String  sql2 = "CREATE TRIGGER Trigger_Insert_" +  table  +
                "　   AFTER INSERT "+ 
                " ON "+ table + 
                "  BEGIN "+ 
                " SELECT last_insert_rowid(); "+
                " insert into Metadata(NID, tableName , rowId, timeStamp , sync) values(hex(randomblob(16)),'" + table + "'," +
                        "  CAST( last_insert_rowid()  AS INTEGER), datetime('now'),0); END;";

db.execSQL(sql1);

It seems cannot drop trigger, because each time I re-execute this code will alert
trigger exists error.

asked Aug 20 '13 at 07:04

waiter.james

1

Are you really executing `sql1` twice? – CL. Aug 20 '13 at 13:13
Why I should execut it twice? – waiter.james Aug 21 '13 at 03:39
I did not ask whether you think you *should* execute it twice, but whether you actually *do* execute it twice (because that's what the code appears to be doing). – CL. Aug 21 '13 at 06:52
Ok, got it.~But isn't it would be safe with "IF EXISTIS" query? Let me figure out tommr. – waiter.james Aug 21 '13 at 16:03

how to drop trigger of sqlite in Android

0 Answers0