Hi Team,
Does this trigger only work when a record is changed (UPDATED) or when a new record is inserted as well?
{sql}
CREATE TRIGGER "SetDateToFinance" BEFORE UPDATE OF "JobStatus" ON "JobTickets"
BEGIN

IF OLDROW.JobStatus <> 'FI' and NEWROW.JobStatus = 'FI' THEN SET NEWROW.DateToFinance = CURRENT_TIMESTAMP;
END IF;

END
{sql}
If it doesn't work for INSERTs then I need to add another Trigger for that condition.

Regards & TIA,
Ian

I need to trigger to operate for INSERT & UPDATE.

Ian



Correct - give that man a Kewpie doll

If you don't know what a Kewpie doll is - https://en.wikipedia.org/wiki/Kewpie

Roy Lambert

Hello Ian,

To create a trigger that works both for insert and update do this:

CREATE TRIGGER "<YourTriggerName>" BEFORE ALL ON "<YourTableName>"
WHEN OPERATION = 'Insert' OR OPERATION = 'Update'
BEGIN
 ...
END

--
Fernando Dias
[Team Elevate]

Roy, Yes I know what a Kewpie doll is.  I am that old.
Not that I ever had one of course.

Fernando,
Thank you, I will have a play.
I still need to separate the actions between the BEGIN - END as obviously in an INSERT there is no OLDROW

Regards,
Ian

Ian,

<<I still need to separate the actions between the BEGIN - END as obviously in an INSERT there is no OLDROW>>

Right, but thats easy:

BEGIN
  
  IF OPERATION = 'Insert' THEN
    ...
  ELSE
    ...
  END IF;

END

--
Fernando Dias
[Team Elevate]

Fernando


I tend not to use that one much and had forgotten it

Ahhh the joys of aging.


Roy Lambert

Thanks Fernando,
Still so much to learn...

Regards,
Ian

Roy,

<< Ahhh the joys of aging.>>

The alternative is way worst


--
Fernando Dias
[Team Elevate]