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