[Moved to DUG-DB]
> Try writing that in a single fast SQL statement!
Are you able to build up the SQL string only for the items that have been
defined and EXECUTE(@statement) that?
Another method that's simplified the code and debugging for me is to use a
temp table created with SELECT * INTO on one selection, and then apply
remaining restrictions to that set.
Depends on your situation I guess.
Paul Ritchie
Radio Computing Services
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
