Hi Perry

I have an application with 4 large FoxPro tables (each between 30 - 80 MB) and a couple of small tables, and in this application I use SCAN...ENDSCAN instead of a complex SQL-SELECT.

Try both methoes to see what's fastest in the current citiation.

>Hi,
>
>I'd like to know, would a SCAN...ENDSCAN retrieve data faster than an SQL-SELECT from a remote server???? I'd like to add an OLEBar for download progress into my form, and I was wondering which would be the better to use.
>
>I almost forgot, my SELECT has 3 conditions to meet.
>
>TIA