Hi, ALL, I want to create a trigger on the table. The trigger will be fired before insertion. In that trigger I want to check if the data is already present.
I have: CREATE TABLE test( id integere primary key, name varchar(70)); INSERT INTO test( NULL, "abc def" ); INSERT INTO test( NULL, "def abc" ); Can I prevent the second insertion with the trigger? Or I should make some app logic to prevent that? Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
