do while nSQLRet=0 nSQLRet = SQLExec(hConn,"SELECT * FROM PREREG","getreg") enddo SQLCANCEL(hConn)Unfortunately, yes I do need to fetch such a large recordset. This has to interact with an off-line legacy FoxBASE+ application (yes, I still use that!), so from time to time I need a full data dump.