Hello Sqlite users, experts, I am in a state of confusion and I request you to help me out please.
Can "INSERT OR REPLACE" trigger if actual operation performed is REPLACE? Say , For example, if I have 2 triggers on table T1, one trigger, say insert_trigger, is set to trigger after INSERT, and another, say update_trigger, set to trigger after UPDATE. If INSERT OR REPLACE statement performs INSERT operation, the insert_trigger is being invoked, which is fine. IF INSERT OR REPLACE statement performs REPLACE operation, then again insert_trigger is being invoked, which as per the documentation ( i.e it actually performs DELETE and INSERT) is fine. Am I wrong in expecting that INSERT OR REPLACE should trigger update_trigger when on the whole the operation performed is actually an UPDATE? I apologize, if my question is too silly. Regards, Bharath ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
