Release 10.1A: OpenEdge Development:
ADM Reference

> ## fetchLast

> Procedure that repositions the RowObject query to the last row of the result set. If the last row has not yet been retrieved from the database, then fetchLast gets the last batch of RowObject records for the SmartDataObject, and then repositions the RowObject query to the last row.

> Location: data.p

> Parameters: None

> Notes:

> - If the SmartDataObject property RebuildOnReposition is FALSE, and the last row from the database query has not yet been fetched, fetchLast keeps asking for batches of rows until the last batch is received. This is required, otherwise there would be a discontinuous set of rows in the RowObject temp-table.

> - If RebuildOnReposition is TRUE, and the last row from the database query has not yet been fetched, all RowObject records are discarded and just the last batch is fetched. In this case, the RowNum of the last row becomes 2000000 (just to start with a high value so that all RowNum values continues to be positive integers), and all other records have smaller numbers (except for additions).

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095