On Sun, Jul 11, 2010 at 01:46:19PM -0400, Sam Carleton scratched on the wall:
> I have some audit fields, one being updatedby, I would like to create an
> update trigger that would prevent the row from being updated if this was not
> set. Can I do that in sqlite?
Define "not set." You can make
On 11 Jul 2010, at 6:46pm, Sam Carleton wrote:
> I have some audit fields, one being updatedby, I would like to create an
> update trigger that would prevent the row from being updated if this was not
> set. Can I do that in sqlite?
Use a TRIGGER on BEFORE UPDATE. In the TRIGGER check that new
I have some audit fields, one being updatedby, I would like to create an
update trigger that would prevent the row from being updated if this was not
set. Can I do that in sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
3 matches
Mail list logo