Release 10.1A: OpenEdge Development:
ADM Reference

> ## serverSendRows

> Server-side procedure called by its counterpart (clientSendRows) when operating in n-tier mode (client, AppServer). This procedure acts as a pass-through proxy to sendRows for assembling and retrieving a batch of records. Runs in the ASHandle if in a SmartBusinessObject.

> Location: data.p

> Parameters:

> `INPUT piStartRow AS INTEGER`

> The RowNum value of the record to start the batch to return. Typically piStartRow is ? as a flag to use pcRowIdent instead of piStartRow.

> `INPUT pcRowIdent AS CHARACTER`

> The RowIdent of the first record of the batch to return. Can also be FIRST or LAST to force the retrieval of the first (or last) batch of RowObject records.

> `INPUT plNext AS LOGICAL`

> TRUE if serverSendRows is to start on the NEXT record offset from piStartRow/piRowIdent. Ignored if pcRowIdent is FIRST or LAST.

> `INPUT piRowsToReturn AS INTEGER`

> The desired number of rows to return.

> `OUTPUT piRowsReturned AS INTEGER`

> The actual number of rows returned. This number is always <= piRowsToReturn.

> Notes:

> - All of the parameters are simply received from the client and passed through to sendRows. The temp-table result is then received from sendRows and passed back to the client counterpart routine.

> - If piStartRow is not 0 or ? then pcRowIdent is ignored. plNext is ignored if pcRowIdent is FIRST or LAST.

> - The most common use of piRowsReturned is to indicate that the entire result list has been returned when it is less than piRowToReturn.

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