>1) CursorAdapter have FetchSize and MaxRecords properties and it is not a local cursor. That is why I didn't understand.
>
>2) What I thought was something like a query that doesn't expose the problem in first N records (and those N records should be based on some where expression - another one causes it to surface).
>
>"When it doesn't populate at all there is something wrong in SQL" is one that I observed with CA. There may be other reasons of course. Did you check with aerror()? I would also step in BeforeCursorFill and AfterCursorFill events.
>
>Also try that query that yiu use in query browser with:
>
DO HOME() + "DataExplorer.app"
>
> And finally maybe you paste the query here so there is a possibility that we can spot something (you use text...endtext already,right?)
>Cetin
Sorry about the delay, clients had problems and then came the Southwest Fox conference (great event!).
It's astonishing what guidance someone else's code can be. I had some property settings wrong and somehow got confused about CA properties and CURSORSETPROP() calls. By simply tweaking and setting some properties to match yours, all works fine now.
Thanks again,
Ken