I'm attempting to create a trigger using DBEAVER and Intersystems Cache Database using the following statement:
CREATE TRIGGER AFTER INSERT trigger1
ON System.get_table1
AS
BEGIN
SELECT * FROM System.get_table2
END;
and im getting this error:
SQL Error [1] [37000]: [SQLCODE: <-1>:<Invalid SQL statement>]
[Location: <Prepare>]
[%msg: < 'BEFORE' or 'AFTER' expected, INSERT found^CREATE TRIGGER AFTER INSERT>]
I've attempted moving the AFTER INSERT around and it doesn't seem to be working.