> Trigger is a plain text remembered and executed at certain points of
> time. If you know your maximum number of employees at the time when
> you create trigger then just put it there instead of question mark. If
> you wanted to change that maximum at each trigger execution then it
> won't work th
Hi everyone,
My C program has a CREATE TRIGGER statement which contains a template "?":
CREATE TABLE employees (
employee_id INTEGER PRIMARY KEY,
dep_id TINYINT,
score FLOAT
);
CREATE TRIGGER on_ins_employee AFTER
INSERT ON employees
WHEN ? < (SELECT count(1) FROM employees WHERE dep_id =
2 matches
Mail list logo