RowScrollSelectNew
Mon 01 January 2018Syntax
RowScrollSelectNew(levelnum, scrollpath, RECORD.sel_recname, [sqlstr [, bindvars]] [, turbo])
Where scrollpath is:
[Record.level1_recname, level1_row, [Record.level2_recname, level2_row, ] Record.target_recname
where bindvars is an arbitrary-length list of bind variables in the form:
binvar1 [, 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 RowScrollSelectNew function is similar to RowScrollSelect, except that all rows read into the work scroll are marked new so they are automatically inserted into the database at Save time.
Note: This function remains for backward compatibility only. Use the SelectNew rowset method instead.
This capability can be used, for example, to insert new rows into the database by selecting data using a view of columns from another database tables.
Parameters
|
Field or Control |
Definition |
|---|---|
| level |
Specifies the scroll level of the scroll area into which selected rows are 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 the record definition 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 with other page records. This enables you to limit the amount of data read into the data 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. The same restrictions that exist for SQLExec exist for these variables. |
| turbo |
Setting this parameter to True turns on turbo mode for RowScrollSelectNew. 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.