Victor,

The way the FetchSize property works is that it fetches all the records, it just does it one at a time (or whatever number you specify). Execution continues once the first record is available, but VFP continues to fetch the rest of the records in the backround. Setting the FetchSize to 1 will make fetching the records very slow. I don't think it will accomplish what you're trying to do. I think you'd be better off requerying your view as needed to make sure you have the most recent data.

>Josh,
>A definate step in the right direction. Situation is this: I have asynchronous checked in the connection, I'm only using 1 remote view in my test form. If I have the FrechSize set to anything less than the total number of records then I get the 'Connection Busy' error. If I have change the ShareConnection setting in the view, same problem. (Which I guess makes sense because their is only one remote view for the form).
>->My problem is that I don't want to have to fetch ALL the records, I just want to fetch one at a time. Is this possible? And even if it is, is it a dumb idea to do so? My assumption is that if user#1 changes a record, then user#2 will see the change right away (when they go to the 'changed' record) if the 'fetching' gizmo is set to 1, right?