Archive for April, 2009

Enhanced Changelogs with DoSQL

Wednesday, April 29th, 2009

For this week's blog article, we want to extend a special thanks to Kevin Frank and Dave Walton who sent us the example.

When using DoSQL to create a ChangeLog of your records, you want to avoid creating log records when nothing has actually changed.

The trick is to prevent DoSQL from firing unless you want to log a change... take a look at the example and check the validation on _K in the Data table... basically, if the parent sees that nothing has changed since the last corresponding ChangeLog record was created, then doSQL won't trigger.

DoSQLChangeLog-2.png

Note that if you have no ChangeLog record for a given parent record, then it will be created *regardless* of which parent field you edit, but... once you have at least one change log record for a given parent, then any "don't log" fields will be respected.

The thing I like about this technique is that ChangeLog records will be created when a Replace is performed and when parent records are imported.

DoSQL ChangeLog Example

DoSQL Plug-in download