0

No work this script

let xResponse := dialog("Delete Warning", "Do you want to delete ALL records?", ["Yes", "NO"]);
if xResponse = "Yes" then
    for i in (select Events) order by Status do
        delete (select Events where Status = "Complete Audit");
        alert(" All records deleted ")
    end
end

3 Antworten

null
    • Kruna
    • vor 10 Monaten
    • Gemeldet - anzeigen

    Hi Rafael,

    I think you need to add text like here

            delete (select Events where text(Status) = "Complete Audit");

    or if you leave text

    you would need to write following:

            delete (select Events where Status = 1);

    if the number is 1

     

    Saludos Kruna

      • Rafael_Sanchis
      • vor 10 Monaten
      • Gemeldet - anzeigen

       

      beginner mistake 😔 Thanks. Kruna

      • Kruna
      • vor 10 Monaten
      • Gemeldet - anzeigen

      no problem, same here 😅