Update one field with a trigger
-
Hi:
Can you helpme? I have a db with a table, this table has a field "expirationdate" and another field "active" (0,1). How can i make a trigger for change the status of the flag if the current time is > than the expirationdate field?
Thank you for your collaboration
-
You don't need the active column, this is something you can calculate either in the select or in the application simply by comparing with the current time.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply