How to auto populate on DateTime on insert or update?
Posted: Tue 07 Jan 2014 21:45
Using Delphi Xe2 and v2.2.5 of LiteDAC Professional and can't seem to figure how to auto populate a DateTime field when inserting a new record into my SQLite table.
For example when using the DBNavigator control to Insert & Post or Edit & Post, etc.
I'm using TLiteQuery, TLiteDataSource along with TCRDDBGrid.
My form also has various DB Control controls like TDBEdit and DBNavigator.
I tried researching online and attaching code to the various events in the controls but I am still stumped.
Edit:
I was assuming that I could do this via code, is this something that must be done using triggers?
Any help would be appreciated.
For example when using the DBNavigator control to Insert & Post or Edit & Post, etc.
I'm using TLiteQuery, TLiteDataSource along with TCRDDBGrid.
My form also has various DB Control controls like TDBEdit and DBNavigator.
I tried researching online and attaching code to the various events in the controls but I am still stumped.
Edit:
I was assuming that I could do this via code, is this something that must be done using triggers?
Any help would be appreciated.