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')

This will return the next 10 rows that are after whatever company is stored within the lcCompany variable. BTW, to get the previous 10, change the > to a < and change the ORDER BY to DESC instead of ASC (the default).

-Mike