Limit number of Rows in a table

From: Marco Wolfgarten <mwolfgarten_at_web.de>
Date: Sat, 21 Jul 2001 21:24:12 GMT
Message-ID: <3b41d911$1@netnews.web.de>

Hi there!

I'm trying to limit the number of rows in a table -> No INSERT must be possible. I tried to do this using a trigger, but I have no idea to forbid the transaction:

create or replace trigger trg_limit_Customers before INSERT ON tbl_Customers declare

	numRows integer;
begin           
	SELECT Count(*) into numRows from tbl_Customers;
	if numRows>25 then
		????? --Do not allow to insert more rows!
	end if;

end;

Does anybody know which command I have to use, or which other solution may fit this problem?

Thanks for your help in advance!

Marco

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de

Received on Sat Jul 21 2001 - 16:24:12 CDT