Advantage ODBC driver and SQL queries..

This message is being posted on behlaf on Nadeem Mian, Systems
Development Assistant for the National Hospital for Neurology and
Neurosurgery, Queen Sqare, London, England.

We are trying to run SQL queries from Delphi, retrieving data from
Clipper databases under the Advantage Server from Extended Systems.
(The Apollo package is not suitable as it cannot handle SQL.) We find
that the Advantage ODBC drivers are very slow and do no cope with our
SQL queries adequately.

We susect that the advantage driver does not utilise the appropriate
index and thus gives very poor response.  Is anyone able to offer help
on this ?

Please reply by email.

Nadeem Mian.
nm...@ion.ucl.ac.uk