Progress
ADM 2 Reference


sendRows (data.p)

Fetches the requested number of rows from the database Query and creates corresponding records in the Row Object temp-table. The batch will typically start at row indicated by the pcRowIdent parameter, but can start on the row indicated by the piStartRow parameter.

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 data 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.

Returns: Nothing (procedure)

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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095