And another thing.
Deactivating the triggers is not an option for me but it works.

        execute statement 'alter trigger files_au0 inactive';
        execute statement 'alter trigger files_bu0 inactive';
        execute statement 'alter trigger pool_loss_record_bu0 inactive';
        update files f
            set f.ccy_total_claim_amount_net = :TCACCY,
                f.ccy2_total_claim_amount_net = :TCACCY2,
                f.date_filter = :DATEFILTER
        where f.file_id = :FILE_ID;
        execute statement 'alter trigger files_au0 active';
        execute statement 'alter trigger files_bu0 active';
        execute statement 'alter trigger pool_loss_record_bu0 active';
  • ... masb...@za-management.com [firebird-support]
    • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
      • ... masb...@za-management.com [firebird-support]
        • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
          • ... masb...@za-management.com [firebird-support]
            • ... masb...@za-management.com [firebird-support]
              • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
                • ... masb...@za-management.com [firebird-support]
                • ... masb...@za-management.com [firebird-support]
                • ... masb...@za-management.com [firebird-support]

Reply via email to