General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank you both for your suggestions. Is there any way to reference the RECNO() of records generated in a cursor, i.e. something like WHERE RECNO() >= 1 AND RECNO() < 11? By the way, the database that I am pulling from is DB2. Thanks.
>Did you try a CURSORSETPROP("MaxRecords", 10, "tablename") or CURSORSETPROP("FetchSize", 10, "tablename")? The way I figure it, SQL creates a cursor on the server-side. FoxPro pulls all that data into one large local cursor, unless you specify otherwise. When you send updates, FP actually updates the server-side cursor which SQL, in turn, uses to update the data.
>
>Phillip
>
>>I am using SQL Pass-Through to pull a cursor from a remote database. The cursor is usually rather large and takes more time than what is desired to pull all the generated records down from the server. What would be the best to incrementally pull the records, i.e. records 1 through 10, then go back and get 11 through 20, and so on to the end? TIA.
>>
>>Bryan
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only