Subject can i ignore invalid record during an insertion?
Author korkless
hi all, sorry if this is a stupid question (i'm new to db)

exists a way to ignore the insertion of an invalid row?

for example if i have a not-null constraint on the id column
when i make an INSERT with a null value as id i want that firebird will ignore that insert operation.

i must do the insertion of a lot of records with an higth percentage of invalid data so i think that if i can manage the exeception (that is ignoring the invalid record) at the database level it's better that managing that at application level.

another stupid question about performance is that, when i must do a lot of insert (~1000) it's better to wrap them into an explicit single transaction or left the default implicit transaction management? (i don't need to rollback all if same insertion fails, every insert is indipendent)