Hi

I implemented the Load Update trigger like this

EXECUTE IMMEDIATE 'CREATE TRIGGER "LOAD_TRIGGER_1" BEFORE LOAD UPDATE ON "Table 1"
BEGIN
  IF LEFT(OLDROW.ID, 4) <> ''ABCD'' THEN
     ABORT;
  END IF;
END';

No records are getting updated whether the above boolean expression is resolved to True or False. "ID" is the primary key of the table and has values "BBBB-B65F" and "ABCD-C255". Those two records where in the same update file. The second record is not processed (or it does not get updated)...

Im using the latest version 2.05b4

Many Thanks

Alfred

Alfred


Try just using single quotes around ABCD rather than double quotes.

Roy Lambert [Team Elevate]

Hi Roy

Many thanks for your reply...

I found the error in my code after I pulled my hair long enough to find it

It has nothing to do with Load Update Trigger...

By the time I came to cancel the thread, I saw your message...

Many thanks again for your kind help

Regards

Alfred