Progress
DataServer for
Microsoft SQL Server
Guide
Cursors
A cursor is like a pointer that points to consecutive records in a table. Progress uses cursors to keep track of where it is in a table; for example, when it processes FOR EACH statements. Suppose that you are reading records from the customer table using the cust-num index, and your current record is customer number 50. This means that Progress has a cursor positioned at cust-num 50. Note that Progress maintains cursor positioning across queries.
The DataServer allows applications that access MSS data sources to imitate Progress cursor behavior for FIND cursors. FOR EACH and OPEN QUERY statements do not retain cursor position against a FIND statement.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |