0

trigger after delete

Hi.

Is there a way to execute a code after delete a record?

 

Thanks

Fabio

9 replies

null
    • Sviluppatore Ninox
    • Fabio
    • 6 yrs ago
    • Reported - view

    Guys?

    • Laura
    • 6 yrs ago
    • Reported - view

    Hi, Fabio, there are probably more elegant ways to do it than this, but here's how I might move a record to a different table. See Candidates.

    https://www.dropbox.com/s/clp3o6ew5f8vk7v/Record%20delete%20example.ninox?dl=0

    • Sviluppatore Ninox
    • Fabio
    • 6 yrs ago
    • Reported - view

    Hi Laura. Thanks for your reply.
    I don't want to move a record in a different table. I need to execute a trigger code after I push the trash button in Ninox.

    Thanks

    Fabio

    • Birger_H
    • 6 yrs ago
    • Reported - view

    Hello Fabio - this is not possible. There is no "onDelete" trigger. But there sure is a workaround.

    Birger

    • Laura
    • 6 yrs ago
    • Reported - view

    Thanks for clarifying, Fabio. 

    • Laura
    • 6 yrs ago
    • Reported - view

    (Just to be clear, the code I wrote in the example above *does* delete a record and then take another action—the other action being creating a record elsewhere—so it might be worth a look anyway, just in case it might do as a workaround.)

    • Sviluppatore Ninox
    • Fabio
    • 6 yrs ago
    • Reported - view

    I already use that solution in other parts of the dB, but it doesn't solve my problem.

    Many thanks..

    Fabio

    • Laura
    • 6 yrs ago
    • Reported - view

    👍

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    HI what would work for  for trigger after delete? 

    i want to delete a reccord in another table that has the same lot# 

    if i use user control to avoid deleting of a record in table 1 it will not let me delete it with a trigger button eighter 

    ( i was going to stop user from deleting using the garbage can and only be able to delete via button , but it share the same permissions) 

    any other way?

Content aside

  • 4 yrs agoLast active
  • 9Replies
  • 2810Views