RowScrollSelect
Mon 01 January 2018Syntax
RowScrollSelect(levelnum, scrollpath, Record.sel_recname [, sqlstr [, bindvars]] [, turbo])
Where scrollpath is:
[RECORD.level1_recname, level1_row, [Record.level2_recname, level2_row, ] Record.target_recname
and where bindvars is an arbitrary-length list of bind variables in the form:
bindvar1 [, bindvar2]. . .
To prevent ambiguous references, you can use Scroll. scrollname , where scrollname is the same as the scroll levelâs primary record name.
Description
The RowScrollSelect is similar to ScrollSelect except that it reads data from the select record into a scroll under a specific parent row, rather than automatically distributing the selected rows under the correct parent rows throughout the buffer.
Note: This function remains for backward compatibility only. Use the Select rowset method instead.
You must use the WHERE clause in the SQL string to ensure that only rows that match the parent row are read into the scroll from the select record. Otherwise, all rows are read in under the specified parent row.
Parameters
|
Field or Control |
Definition |
|---|---|
| levelnum |
Specifies the scroll level of the scroll area into which selected rows will be read. It can be 1, 2, or 3. |
| scrollpath |
A construction that specifies a scroll level in the component buffer. |
| Record. sel_recname |
Specifies the select record. The selname record must be defined in Application Designer and SQL created as a table or a view, unless sel_recname and target_recname are the same. The sel_recname record can contain fewer fields than target_recname , although it must contain any key fields to maintain dependencies page records. This enables you to limit the amount of data read into the component buffers. |
| sqlstr |
Contains a WHERE clause to restrict the rows selected from sel_recname and/or an ORDER BY clause to sort the rows. The WHERE clause may contain the PeopleSoft SQL platform functions that are used for SQLExec processing, such as %DateIn or %Substring. |
| bindvars |
A list of bind variables to be substituted in the WHERE clause. |
| turbo |
Setting this parameter to True turns on turbo mode for RowScrollSelect. This will improve the performance of ScrollSelect verbs by as much as 300%, but should be implemented with caution on existing applications. See . |
Returns
The number of rows read (optional.) This counts only lines read into the specified scroll. It does not include any additional rows read into autoselect child scrolls of the scroll.