It really should be rewritten/updated. 1. First select should use new type join kind not comma join kind.
<SL> +1 2. Field po_number should be prefixed with alias of the table. <SL> +1 3. Order of exception and update should be reverted, sussped removed, also maybe this update should be run in autonomous transaction but this is not nescessary as someone can commit after this error. <SL> AFAIK, an Exception “kills/terminates” the current operation and any changes done are undone – regardless of commit.
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
