Hello,

In a java code, I create a trigger which acts after insert in a table named contact.
This is the code:
private static final String DB_CREATE_TICONTACT =
"CREATE TRIGGER ti_contact after INSERT ON contact " +
"begin" +
" INSERT INTO tracestable VALUES ( 'contact','insert', new._idcontact, datetime());" +
" end; ";


public void addticontact(){mDb.execSQL(DB_CREATE_TICONTACT);}

The trigger is created, but when I try to insert a new values in the contact table I couldn’t, however if the trigger is deleted (or before creating it) I could!!

Could someone help me?

Thank you in advance.