>>Can you post your CA definition?
>
>For the cursoradapter in the dataenvironment, the nondefault properties are..
>
>Alias 'cursoradapter1'
>AllowDelete = .F. (Made no difference if AllowWhateverOperation was .T. or .F.)
>AllowInsert = .F.
>AllowUpdate = .f.
>Cursorschema = 'CPARTNO C(18), CPARTDESCRIPTION C(52), IDPARTS I'
>datasource = oapplication.odbchandle
>datasourcetype = ODBC (I've tried ADO too - same problem)
>FetchAsNeeded = .T.
>FetchMemo = .F.
>KeyfieldList = 'idParts' (I've tried with and without this - since no updates then it should not be needed)
>Name = cursoradapter1
>SelectCmd = 'select cpartno,cpartdescription,idparts from base.parts order by cpartno'
>SendUpdates = .f.
>
>AutoOpen and Init methods are standard VFP cursoradapter code from the builder.
>
>I've set FetchSize to various sizes and the cursoradapter seems to fetch that many records when it needs them.
Review
http://www.code-magazine.com/article.aspx?quickid=0703041&page=2 may be it would work better for the job.
If it's not broken, fix it until it is.
My Blog