Hi,

I want to browse a recordset produced by a SQL Select:

nSQLHandle  = SqlConnect (cSQLDataSource, cSQLUserId, cSQLPassword)

cSQLcommand = "Select * From MyTable"
SqlExec (nSQLHandle, cSQLcommand, "CurSelect")
Select CurSelect
Browse

The SqlExec function above will execute until all records contained in MyTable are moved to CurSelect, and then control will be passed back to the program. When the amount of records to be selected is very large this statement sequence is not a good choice, because the SqlExec will delay a lot of time and will bring lots of, perhaps, not desired records.

The behavior I'm looking for is that one implemented by a regular FoxPro Browse statement when issued to a DBF file.

How can I implement such a behavior, using SPT?

TIA,

Fernando