close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Highlighting when a particular field has changed

Thread begun 2/20/2015 6:49 am by iain331081 | Last modified 2/25/2015 12:18 pm by iain331081 | 2635 views | 8 replies |

iain331081

Highlighting when a particular field has changed

I know that you can easily have a Last Updated field that can record the date a change was made to a particular record.

But is it possible to record when a change is made to a particular field?

Sign in to reply to this post

Jason ByrnesWebAssist

posible, but not that simple.

you would need a new field to record when the specific field is updated.

then add a lookup recordset to look up the value that is being passed for that filed on the update. if the lookup recordset count returns 1, then the value is not changed, don't change the date for the tracking field. if the look up recordset count returns 0, the value has changed, so update the date in the tracking field to todays date.

if you need help setting this up, we could help through a premiere support appointment:
http://www.webassist.com/premier_request.php

Sign in to reply to this post

iain331081

Thanks Jason - it is a bit of a pain, but basically have a client wanting to know when changes were made, and who made them, on a per field basis. So if there are 20 fields, by the sounds of it there would need to be two extra fields (date and username) for each to record that.

I hate stuff like this where a client insists its something that must be easy to do, because the database must somehow log changes.

Sign in to reply to this post

Jason ByrnesWebAssist

yeah, you would need the 2 extra fields for each column, and a lookup recordset for each also.

Sign in to reply to this post

iain331081

Would there be a way of doing it with an additional table to somehow log the changes? The extra fields might be completely impractical if it needs two extra fields plus a recordset for each column?

Sign in to reply to this post

Jason ByrnesWebAssist

yes, you could create a spirit table with a column to record the name of the field changed, and the date, but it still needs a recordset to determine if changed.

Sign in to reply to this post

iain331081

OK - so for example if I have a table:

Lodges

LodgeID
Lodge_Name
Lodge_Summary
Lodge_Details

I'd need another related table:

Lodge_Updates

UpdateID
LodgeID
Field_Updated
Date_Updated
Updated_By

And the way it would work is that when the update button is pressed it calls a recordset which somehow compares the new value of each field with the old value, and if its not the same inserts a record in the Lodge_Updates table?

Sign in to reply to this post

Jason ByrnesWebAssist

Yeah, that sounds about right.

Sign in to reply to this post

iain331081

Thanks Jason - this is definitely something that I think will need to get done if possible. I'm going to have a look at SQL triggers, but its new to me, so its quite likely I'll come back to this as some paid support.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...