Release 10.1A: OpenEdge Development:
ADM Reference

> ## sendRows

> Procedure that fetches the requested number of rows from the database Query and creates corresponding records in the Row Object temp-table. The batch typically starts at the row indicated by the pcRowIdent parameter, however, it can start on the row indicated by the piStartRow parameter.

> Location: data.p

> Parameters:

> `INPUT piStartRow AS INTEGER`

> The RowNum to start on. An undefined value `(?)` indicates that the next argument (pcRowIdent) determines the start of the batch to be returned.

> `INPUT pcRowIdent AS CHARACTER`

> An alternative to StartRow. It is either FIRST, LAST, or a comma-delimited list of database ROWIDs. If it is FIRST or LAST, the first or last batch of records in the result set is retrieved and piStartRow is forced to `?`. If it is a comma-delimited list of database ROWIDs, the batch starts with a RowObject that comprises those records.

> `INPUT plNext AS LOGICAL`

> TRUE if the query should perform NEXT/PREV (depending on the direction of navigation) before starting to return more rows. In other words, SKIP to the next record at the start of the batch.

> `INPUT piRowsToReturn AS INTEGER`

> The maximum number of rows to return (supply a negative value to move backwards in the result set).

> `OUTPUT piRowsReturned AS INTEGER`

> The actual number of rows returned.

> Notes: Before returning, sendRows repositions the RowObject query to what was the current row when it started. The pcRowIdent argument is used by fetchRowIdent to allow query repositioning to a specific database query row.

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