How to update all the records in a table with SQL?

gvc · Post by **gvc** » Tue Jul 30, 2024 9:28 am

What event do I use to update all the records in a table with this SQL? What is the correct syntax?

UPDATE ListDecades SET Finish = CASE WHEN YEAR(CURDATE()) - DecadeInteger < 0 THEN 0 ELSE YEAR(CURDATE()) - DecadeInteger END, Start = CASE WHEN YEAR(CURDATE()) - DecadeInteger - 10 < 0 THEN 0 ELSE YEAR(CURDATE()) - DecadeInteger - 10 END

mobhar · Post by **mobhar** » Tue Jul 30, 2024 9:34 am

You may use ExecuteStatement global function to execute your SQL Update above. If you want to update after editing an existing record, then you may put that code in Row_Updated server event.

gvc · Post by **gvc** » Tue Jul 30, 2024 8:37 pm

Perfect! Thank you!

Gary