RE: [DUG]: embedded database.

[Paul Ritchie]

[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 - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"