Try wrapping your insert query in a transaction. If insert fails, rollback transaction. At this point the database is returned to normal and you should be able to continue processing.
Charlie
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only