>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

1. Here's the query in all its glory <g>:
SELECT * FROM RESEARCH.SQAWARDS WHERE NIIN = '004682478' ORDER BY AWARD_DATE DESC

2. I've never been able to get DataExplorer to work with MySQL - it can't seem to make a connection though I have no trouble at all with SPT.

3. The problem is worse than not populating; a query with empty results gets a cursor. If the result set is greater than 99 records, I don't get any cursor at all. Instead, I get .T. form CursorFill(), no AERROR() problem - there isn't an error. Then, selecting the cursor gives me an error because the cursor doesn't exist; a LIST STATUS confirms that.

Ken