你可以复制编辑的/将数据删除到另一个名为operation_log的表中，其中包含编辑/删除的原因，编辑/删除的用户等，然后运行编辑/删除代码。


for add i don''你认为你需要复制operation_log表中的数据，但是你可以存储一些信息，即添加新数据和新数据。


希望它能正常工作。 ：！

you can copy the edited/deleted data into another table named like operation_log with the reason of edit/delete, user who edited/deleted etc and after that run the edit/delete code.

for add i don''t think u need to copy the data in operation_log table, but u can store some information that who is adding new data along with new data.

hope it''s work. :!

感谢Ariful。


我环顾四周，大多数使用Audit Trails的人使用模块。模块的问题在于我希望用户能够添加themsleves的原因并输入他们用于更改的文档。该模块更自动，非常适合跟踪用户和进行更改的位置，但我想要这样，以及为什么用户正在更改数据。

Thanks Ariful.

I''ve looked around and most people that use Audit Trails use Modules. The problem with the Modules is that I want the user to be able to add the reason why themsleves and enter the document they are using for the change. The Module is more automatic, great for tracking the user and where the change is made but I''d like that and a WHY the user is changing data.

用于编辑/删除您可以使用查询（删除/更新查询）意味着编辑/删除的表单将与添加新数据的形式分开。您可以在编辑/删除表单中添加一个名为remarks的额外字段。你可以添加两个名为update和delete的按钮。每当用户点击更新/删除按钮时，将检查备注字段是否已填满。如果填满，那么将使用备注数据进行从实际表中复制该数据的查询。然后执行更新/删除查询。


希望它有所帮助。

for edit/delete you can use query (delete/update query) means the form for edit/delete will be a separate form from the form of adding new data. And you can add a extra field in edit/delete form named remarks. And you can add two button there named update and delete. whenever user click on update/delete button those will check the remarks field is filled up or not. if filled up then the query to copy of that data from the actual table will happen with the remarks data. And after that the update/delete query will execute.

hope it''s help.