I have a series of date fields that expire (or need to expire). Currently they do not - UnStored
I have them set to unstored for two reasons - First performance second I have conditional value lists only grabbing current dates.
Not expiring is a big deal -
The present idea is to run a server script at night the basically updates each record to grab a new stored value. The dates only need to update once per day to be current.
Do I need to troll over each record in the table and copy a field to itself or will updating one record in the table update all of them?
Is this the best option to handle this function?
Thanks in advance