Jump to content

Archived

This topic is now archived and is closed to further replies.

klinmy

update all records at once?

Recommended Posts

i'm doing a form which the admin can enter a particular date for the system's users. Different users may have different dates which will be deducted by the current date in order to get the duration.

my question is, can i make a button which can update all the duration of the system's users in the database, so that the admin doesn't need to update the duration one by one when it enters a new year?

thanks

Share this post


Link to post
Share on other sites
I don't really understand your question, but if you want to go into the database and select all records, or a group a records, and adjust a date? by the same amount, or be a formula, then yes... you can do that.

Share this post


Link to post
Share on other sites
As AV1611 said, yes you can, but why bother? The durations can be calculated when required so no need to store such derivable data in the DB. By tomorrow they are going to be out of date.

Share this post


Link to post
Share on other sites
thanks alot.. i will try todo tht.

i need the duration, coz it involves in another calculation in other forms

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.