By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,838 Members | 2,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,838 IT Pros & Developers. It's quick & easy.

Form data change capture

100+
P: 553
Hi

I know i have posted similar question before but there is something i need to ask further to that.

If you have many text-boxes on the form and you want to check if any changes to the data in the textfields is made , how would you capture the changed data (the new data) . And if you want to capture the old data as well (the one that got changed later)

Capturing will be just storing it in another variable or assigning to a field in table.

Any ideas ?

Thanks
Qi
Aug 24 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
What you’re talking about is creating an audit log table, which is not an easy endeavor. I would suggest searching here and googling this term. But from other posts here you’ve been told how to tell Has data been changed and How to loop thru controls.

So, if any data in a record has been changed, loop thru the controls and compare the old value (MyControlName.OldValue) with the current value (MyControlName.Value) and if they’re different, assign them in whatever fashion you want to an audit table.

Linq ;0)>
Aug 24 '07 #2

100+
P: 553
Thanks missinglinq..
What you’re talking about is creating an audit log table, which is not an easy endeavor. I would suggest searching here and googling this term. But from other posts here you’ve been told how to tell Has data been changed and How to loop thru controls.

So, if any data in a record has been changed, loop thru the controls and compare the old value (MyControlName.OldValue) with the current value (MyControlName.Value) and if they’re different, assign them in whatever fashion you want to an audit table.

Linq ;0)>
Aug 24 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
As I said earlier, tracking these kinds of changes is not for the faint of heart, but Allen Browne gives an excellent explanation of how to Create an Audit Log at this site.

Linq ;0)>
Aug 24 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.