I'm new to this and will try to read the documentation, but could someone point me in the right direction please?

We have a **ModifiedDate **field on every table. Ideally I would like to update this to Now() when Inserting or Amending.

Can I do this globally, or do I have to do it for all tables specifically, eg Employees.ModifiedDate?

What are you using: adapter or selfservicing?

We are using Adapter.

Hi,

A solution if you don't want to modify each time the field is to use OnPropertyChanged() method. When a field is modified, in the OnpropertyChanged, you can modify the date field and so insert Date.Now().

We have templates available (for customers, but I can mail them to you) which generate a common base class between the generated entities and the central base class EntityBase2. You could add to that generated class the override of that OnPropertyChanged method so it works for all entities.

You can also use a different route: Create a partial class of DataAccessAdapter in the dbspecific project and override OnBeforeEntitySave and set the field there. This then works for all entities as well.

In there do something like: entitySaved.SetNewFieldValue("ModifiedDate", DateTime.Now);

it then will be included in the query when the query is generated

Thanks. I'll get back when we've bought the product.

Sorry for the delay but I've been coding all day. I've written 5 lines of code and my form shows my table in a Janus grid.

I have RSI now.