Walter wrote:
I have a control table, which could have one row and just one row, never more. Which trigger I should write for prevent inserts in that table if there is one row?
Svein Erling Tysvær answers:
Very simple Walter. Add a PK field and then have a before insert trigger that looks something like:
CREATE TRIGGER WalterTrigger FOR ControlTable ACTIVE BEFORE
INSERT OR UPDATE POSITION 0 AS
begin
new.PK = 1;
end