Thx guys
J

>Hi Jaime you can set the FetchAsNeeded to true this way vfp will only get the FetchSize records at a time and as you are going trough the view vfp is fetching the data now some things to get in considuration if you use fetchasneeded then until all the data is pull down your connection is busy, if you issue a go bottom or index then all the data is pull down from the server-
>
>>Hi
>>If i create a remote view to an ODBC data source, how can i play with the way it fetches the data from the data source? Is there a command that lets me manage the quantity of records fetched, or just that can force a requery of the data ( in case it changed in the meantime? )
>>
>>TIA
>>Jaime