Hi Mark,

>
>Notice how you have command back. I can't figure this out. The only way to stop from getting command back is to put a RECCOUNT() in the AfterCursorFill event, so it waits until all the data is in the ALIAS.
>
>I have tried setting SQLSETPROP(loca.DataSource, "Asynchronous",.f.) (returns .t.), but that didn't make a difference.
>
>
>Howerver, if I use SQLSTRINGCONNECT() and SQLEXEC(), it waits unil the ALIAS is populate before returning control.
>
>What am I missing???

If you want all records to be fetched at once, set CursorAdapter.FetchSize=-1.
But you don't really need to do this because VFP fetches additional records during idle time (see CursorAdapter.FetchAsNeeded property) or when it is needed. For example INDEX ON ... will fetch entire result set automatically as well as GO BOTTOM, RECCOUNT(), etc.

Thanks,
Aleksey.