>Mike,

Woops, nevermind. I went back and re-read the SQL docs to see that Top n & Order by, orders the result set before sending records, so I don't need an index.

But I'm still curious about FetchSize in conjuction with FetchMore

PF

>
>Thanks,
>
>Pf
>
>>I don't think that the FetchSize property will solve your problem. FetchSize determines the number of rows that VFP wait to receive before releasing to the program and retrieving the rest in the background.
>>
>>Is there anything in the table that even close to unique? You may be able to use the TOP command to limit the return results to 10. For example:
>>
>>

>>LOCAL lcCompany, hConn, lnResult
>>
>>hConn = SQLCONNECT(...)
>>lnResult = SQLEXEC(hConn, ;
>>  [SELECT TOP 10 company FROM customer WHERE company > ?lcCompany ORDER BY company], 'c_companylist')
>>