Where should I run a function whose task is to maintain the status of a table record?
For example, I have a survey table with the column status. A record's status is "open" when a user answers it, and it is set to "completed" when a user finishes answering it. But, if in case the user doesn't finish answering it the status remains open, and I want to set to something like "expired" if it isn't completed after a period of time. Thanks, /r Nik