Subject About default values
Author Clément Doss

I would like to use 2 date fields in my tables:

Both would have a 'NOW' default value when inserting.
LastUpdate_Date would be updated when the record is updated too.

I don´t want the user the insert a value in those fields, but I have to show them these values.
So, in the select I will have to include them, but at insert and edit/update not right?
Can I use IBO properties INSERTSQL and EDITSQL for this? By using them, I wouldn´t include the
fields in the expression and the problem would be solved.
Is there a better way to do this?

Best regards,

By the way... Should I ask Santa for two special field types such as AtInsertDate and AtUpdateDate
that would do this all by themselves? :-)