1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • TRIGGER - Syntax Error

    From rnexer@gmail.com@21:1/5 to All on Sun Jun 5 16:54:53 2016
    Hi! I'm new with Informix. I'm trying to create a trigger of a table named "usuarios" that contains the following columns: {email (pk), name, password, created_by, modified_by, date_created, date_modified }.
    I have this code:
    CREATE TRIGGER TR_USUARIOS_BI
    INSERT ON usuarios
    REFERENCING NEW AS NUEVO
    BEFORE (NUEVO.created_by = "rnexer");

    I always get the same error:
    A syntax error has occurred.
    Error Position: Ln: 3 Col: 9

    I don't know what's wrong.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)