Subject | About default values |
---|---|
Author | Clément Doss |
Post date | 2001-12-17T20:19:03Z |
Hi,
I would like to use 2 date fields in my tables:
Insert_Date
LastUpdate_Date
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,
Clément
By the way... Should I ask Santa for two special field types such as AtInsertDate and AtUpdateDate
that would do this all by themselves? :-)
I would like to use 2 date fields in my tables:
Insert_Date
LastUpdate_Date
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,
Clément
By the way... Should I ask Santa for two special field types such as AtInsertDate and AtUpdateDate
that would do this all by themselves? :-)