>hi all !
>i test my application with share data folder in remote server with vpn
>i found that the tradition way is much much faster than the sql statement
>
>use \\server\data\mytable order ac
>seek m.ac
>do while ac=m.ac
> *** get some data and append records into tempcursor....
>enddo
>sele tempcursor
>brow
>
>i try sql statement
>sele * from \\server\data\mytable where ac=m.ac into cursor tempcursor
>i've found that it takes very long time to show the tempcursor
>
>why ?

See if this http://www.berezniker.com/display/VFP/Queries+and+Filtered+Cursors may apply.