Restrict your query size by date for example. Or if size is potentially unknown get a count before you select and if the count is too large don't allow the query. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
- [DUG]: Coping with large datasets Greg Nixon
- Re: [DUG]: Coping with large datasets Kerry Sainsbury
- RE: [DUG]: Coping with large datasets Carl Reynolds
- Re: [DUG]: Coping with large datasets Tony Goodrich
- Re: [DUG]: Coping with large datasets Greg Nixon