Hi Elen,
I mean stop the total number of rows in a table.
I thought to write a before insert trigger but was not sure this is
the best and save way to solve the problem.

Rgds
Paolo Fenelli.

--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> At 06:57 AM 25-06-02 +0000, Paolo Fenelli wrote:
> >Hi Jason,
> >thanks, but I wasn't clear enought. I meant to limit FISICALLY the
> >rows in a table.
>
> What exactly *do* you mean? Your subject is "Limit rows number in
> TIB_Query". Do you mean, how to stop the total number of rows in a
table
> from exceeding n? or how to ensure that "not more than n rows are
in a
> query's result set"? or something else?
>
> regards,
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at
> www.ibobjects.com