What is wrong with this code?

Posted in 1999

Aurelio — Thu, 08 Apr 1999 18:24:47 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, I use this trigger to re-use id's on table t1 CREATE TRIGGER D_t1 DELETE ON t1REFERENCING OLD AS deleted_id FOR EACH ROW ( INSERT INTO Free_ids_for_t1 VALUES (deleted_id);) I receive the error: [Informix][Dynamic Server][dbname] SQL Error (-201) : A syntax error has occurred. The version is 7.2 unix. I think I have followed the spec. in the syntax manual. Any idea?

Related threads

Force Assert Fail
IDS Function problem