--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> well if you are using tables, let's follow this logic..
>
> the same sort of thing can happen if you select * from table
>(as a query) with no limiting clause...

Thanks for the helpful reply.

When you say it's a good idea to limit the number of records
returned by a query, I'm wondering how best to implement this.

Obviously it could be done by having a series of SQLs, each with an
appropriate WHERE clause. Is there any neater, automatic way of
achieving this (through adjustment of Firebird/Delphi/OS parameters)?

Thanks.

Gary