Hi,
I think this is not possible. The exception will “revoke” the update and “crash” the whole transaction.
You can raise an exception in an on delete trigger or revoke the “delete-grant” to prevent deleting on database level. In your application you can have a delete button for the user, but Your code must do an update not a delete.
Regards
M. Pannier
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit
https://groups.google.com/d/msgid/firebird-support/CABkiRz8xyXj%2BwhZ0tWPHmFpPew_sb9cN8k2uUYQFGfWCdHAJvw%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/ad6a288e-a2f2-1073-2f59-ba5cbf971e0c%40ibphoenix.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/8013c98c-d23e-2a3e-7989-e75d780bc024%40ibphoenix.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/00fa0380-8dca-7912-2710-c895c93a339e%40ibphoenix.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4f476c07-d2bf-72b1-d0a0-dafbf3152610%40ibphoenix.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/1053fa88-cd0f-feaa-f98d-798cce1278bd%40ibphoenix.com.
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CABkiRz8xyXj%2BwhZ0tWPHmFpPew_sb9cN8k2uUYQFGfWCdHAJvw%40mail.gmail.com.