James,
it appears from your code that you have asynchronous turn on. I would suggest that you first set it off using:

=sqlsetprop(mHandle, 'asynchronous', .F.)

*
and see if that makes any difference. Also, you might want to try this code with Asnyc on. That's the way I have used it. Not sure if it makes any difference but...

SQLResult = sqlexec(h, "select * from MySQLTable", "MyCursor")
do while not SQLResult > 0
  SQLResult = sqlexec(h)
enddo

HTH, John.


>When I issue the following SQLExec(), I got a maximum of 100 rows in MyCursor. What do I need to do to retrieve all rows to MyCursor?
>

>SQLResult = sqlexec(h, "select * from MySQLTable", "MyCursor")
>do while SQLResult == 0
>  SQLResult = sqlexec(h)
>enddo
>

>
>Thanks