0

Delete multiple records?

Say I do a search and want to delete those "found" records? How do I do that?

Also, say I just want to empty a table but not delete it. How is that done?

Thanks,

7 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Through a script?

    • ninox.1
    • 2 yrs ago
    • Reported - view

    I was hoping there was an interface way to do it, but haven't found it. I'm assuming you can select records and then delete them (somehow) in a script, but I haven't found an example.

    Thanks Fred.

    • Fred
    • 2 yrs ago
    • Reported - view

    If you ctrl+click the line numbers in a table view you can select all. Then do it again and select Delete selected rows.

    You can do this after you filter or if you want to clear your table then make sure no filters are applied.

      • ninox.1
      • 2 yrs ago
      • Reported - view

      Fred That doesn't seem to work with the cloud version. Ctrl-click doesn't show anything. Is that just for the Mac app?

      • ninox.1
      • 2 yrs ago
      • Reported - view

      Mike But it works fine in the local app. Thanks Fred!!! :)

    • Fred
    • 2 yrs ago
    • Reported - view

    If you need to repeatedly delete the contents of a table then you can put this in a button: 

    delete (select TableName)

    Of course I would be very careful with this. You can put an a dialog in front: 

    let xResponse := dialog("Delete Warning","Do you want to delete ALL records?",["Yes", "NO"])
if xResponse = "Yes" then
    delete (select TableName)
    alert("All records deleted")
end
      • ninox.1
      • 2 yrs ago
      • Reported - view

      Fred Nice! Thanks Fred.

      You're the best.

Login to reply

Content aside

Categories

View all topics
  • 2 yrs agoLast active
  • 7Replies
  • 277Views
  • 2 Following