I am developing an android application that uses the database spatialite, I use this project to integrate the database on android https://code.google.com/p/spatialite-android/ It works normally, except when I use the clauses' UPDATE 'or' INSERT' it there's the trigger that prevents the request to be executed, i get the following message:'geometry violates Geometry constraint [geom-type or SRID not allowed]. whatsoever geometries that I want to update or just attribute data, but when I execute the same clause in spatialite_gui for example, it works normaly. I tried to delete the trigger, the problem is solved, but after it is impossible to execute spatial queries, the table is corrupted. I can't understand or locate the problem,to try to solve it
Why the trigger prevents 'insert' and 'update' on android and not on saptialite_gui?