Hello SC My goal is that on an insert only the insertedby value is provide. The SC trigger will set that to the updatedby, insertedon and updatedon SC fields. I searched the web and the only examples I could find was of SC an AFTER INSERT, am I better off with that approach? I would think SC not.
How about using default values when you create the table, e.g. CREATE TABLE Customer ( CustomerId INTEGER PRIMARY KEY AUTOINCREMENT, IsInSlideShow INTEGER NOT NULL, Username CHAR(50) NOT NULL, Password CHAR(50), insertedby CHAR(50) NOT NULL, instertedon DATE DEFAULT CURRENT_DATE, updatedby CHAR(50) NOT NULL, updatedon DATE DEFAULT CURRENT_DATE, UNIQUE (username)); You can then do an insert as: INSERT INTO Customer (insertedby, updatedby) VALUES('me', 'me'); i.e. pass the same value for both columns. Hope this helps. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users