I am looking for hints how to do the following. Thanks in advance.
In this example link, I would like to have the Modify date automatically set to current date after the row is created or edited, without including it in the edit form.
This question has accepted answers - jump to:
If this is a MySQL database, you need a timestamp column with a default value of "CURRENT_TIMESTAMP" and an attribute of "on update CURRENT_TIMESTAMP".
Modifying any field will then add current timestamp to the row.
Thank you so much. It works like a champ.
How we can do it in a sql database? should I create a trigger on my table?
Hi @firstname.lastname@example.org ,
Yep, that's a good way to go. This SO thread has some details,
Thanks colin, it works well.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.