#647 sqlparam asks parameter substitution for triggers

2.6.6
open
Unknown (89)
5
2012-12-29
2008-07-18
Anonymous
No

I cannot create the following trigger because sqlparam asks a value for :NEW

CREATE OR REPLACE TRIGGER TR_ACCOUNT_UPDATE
BEFORE UPDATE ON ACCOUNT
FOR EACH ROW
BEGIN
:NEW.MODIFICATION_TMS:=SYSDATE;
END;

Discussion

  • Rob Manning

    Rob Manning - 2008-07-18

    Logged In: YES
    user_id=1287991
    Originator: NO

    The sqlparam plugin can be disabled while you are waiting for this fix. Choose Plugins -> Summary then uncheck LoadAtStartup and restart.

    Rob

     
  • Nobody/Anonymous

    Logged In: NO

    see also 1904859 ("::" stands for typecasting - postgresql)

     

Log in to post a comment.