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.