>>Do you mean setting remote view on whole table and then SCAN it? In Russian, it's called touching by right foot to the left ear.
>>
>>>Hi Ed (and Perry)!!
>>>
>>>You can actually SCAN...ENDSCAN a remote table regardless of back-end source...not that you'd want to.
>>>
>>>
>>>>>
>>>>>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
>>>>
>>>>Probably, you mean VFP database, and not back-end server (because SCAN is applicable to VFP only). If this is a case, then the difference is following: SEEK/SCAN will be faster if you retrieve few records (few may mean even few hundreds). However, the bigger is number of retrieved records, the faster comparable SQL-SELECT will be.
>
>In US its called going around your butt to get to your elbow.
>
>Jeff

not bad :)