No announcement yet.

Navicat SQLite 12 ignores triggers on views

  • Filter
  • Time
  • Show
Clear All
new posts

  • Navicat SQLite 12 ignores triggers on views

    I’ve been a long time user and promoter of Navicat, especially for SQLite on the Mac. Years ago I published a detailed (and ugly) comparison of various SQLite clients fro the Mac at:

    I have been using Navicat Essentials for SQLite version 11.2.18 successfully.

    I recently downloaded the Navicat for SQLite version 12.1.23, but found some problems.

    In version 11, when I open a view that has an “instead of insert” trigger, Navicat allows me to add a new record to the view. In Navicat version 12, the `+` “Add Record” button is disabled and does not allow me to insert.

    Similarly, when I try to change the value of a value in a record in a view that has an “instead of update of” trigger, version 11 allows it, but version 12 does not.

    This appears to be a bug and makes the upgrade unusable for me.

    Thank you,

    Tom Brodhurst-Hill
    BareFeetWare 👣

  • #2
    Hi Tom

    We are able to identify the problem and our development team is trying to fix it. We will contact you after the bug is fixed.