I want to include a field in my database that holds the date and time that a record was last changed.

Is there a way in LLBL that I can retrieve the database clock time (i.e. the time on the SQL server or firebird server) so that I can then populate the field with the server time before saving. I assume it would be a case of creating a new DataAccessAdapter and calling some method?

I could use triggers but I find that messy as some of my business logic resides in the database and some is in the application.

No there is no such function at the moment.

Otis wrote:

No there is no such function at the moment.

Couldn't you just expose "select GetDate()" in a stored procedure and access the information that way?

Hal

OK, I will use a work around