How can Trigger be used to keep track of a field?
If I have a page, with a textbox, a checkbox and a submit. Based on the checkbox, I update a field in the database and trigger does whatever. But also, if there's text in that textbox,I want to keep track of what the user entered. How do I do that? insert that textbox value into another table and keep track of it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes
Id CurrentValue PrevousValue
1 10 5
2 8 NULL
3 13 12
Id CurrentValue PrevousValue
1 10 5
2 8 NULL
3 13 12
ASKER
append it where? you mean just create a new column for the table??