1) It appears the check constraint below it not enforced properly. Why ?

create table tt ( k numeric(8) , v char(10));
alter table tt add constraint ck1 check( 3>(select count(*) from tt) );
insert into table tt(k,v) values (1,'one');
insert into table tt(k,v) values (2,'two');
insert into table tt(k,v) values (3,'three');
This
insert into table tt(k,v) values (4,'four');
results in
"Operation violates CHECK constraint CK1 on view or table TT"

select count(*) from tt;
count
------
3

2)There are STATEMENT triggers in Firebird ? If not, is there a way to
simulate them ?
3) How can I retrieve the count of the row affected by the previous DML
statement in a stored procedure ?



________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com


[Non-text portions of this message have been removed]