Yuri,
The ODBC driver still has to open the table, and do the same work. This only adds another layer on the client side.
And Chris, just because the table is open, doesn't mean VFP had to pull the entire table across the line. Of course that is not much of a consolation to you, because it still is too slow.
>Then REMOTE view should help. Something like:
>
>create data hi
>create connection vfphello connstring (;
> 'Driver={MICROSOFT VISUAL FOXPRO DRIVER};'+;
> 'SourceDB=C:\Foxwork\Vfpapps\;'+;
> 'SourceType=DBF')
>
>CREATE SQL VIEW hello REMOTE connection vfphello share aS;
>SELECT *;
>FROM RECLIST;
>WHERE nIDnumber = 1234567
>
>use hello && table is not open
>
>>We choose the specific record based on a field name nIDnumber; the table is indexed on this field.
>>
>>This is what I tried:
>>
>>OPEN DATABASE DBNAMES
>>
>>CREATE SQL VIEW ViewOneRecord AS;
>>SELECT *;
>>FROM DBNAMES!RECLIST;
>>WHERE nIDnumber = 1234567
>>
>>
>>However, if I "DISPLAY STATUS", I find that the big table is open (as well as the database).
>>
>>CM
Steve Gibson