Is it possibly where the temporary files are created? It might be the creation of the local table that is taking the time.
>Hi guys,
>I am runnign VFP 7. I run a sql query on SQL server 2000 in my command window the result is returned in less than 1 second. If I run the same query in my executable on the same machine usng the same DSN the system hangs on the query. can anyone help me. The table I am querying has 10 million rows.
>
>TIA
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown