www.hkvforums.com

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

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.

Perfect! Thank you!

Gary