What is the difference between %Select and %SelectInit in
Application Engine Peoplecode.
Answers were Sorted based on User's Feedback
Answer / danalaxmy
Both %Select and %SelectInit are similar in the way that
they are used to update the state record fields (specified).
But the only difference is that when we use %Select and no
row is returned by the following Select statement, the
fields retain the previous values whereas when we use
%SelectInit and no row is returned by the Select, the fields
get initialised.
Is This Answer Correct ? | 39 Yes | 1 No |
Answer / bandisdevi
%select: When it select no values the previous values in
state record won't be affected.
%selectInit: It reinitialize the state record to null values
when no values are returned by the select statement.
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / jithendra`
When your select statement is retrieving any row of
data,there wont be any difference between % select and %
select init,But when select statement is not retrieving any
row of data in % select the previous value in the state
record will remain same/unchange,Where as coming to %
select init the previous value in the state record will be
intialized to null values.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / hari.sidd
%SELECT() AND %SELECTINIT() BOTH ARE USED TO PUSH VALUES
INTO A STATE RECORD IN AN APP ENG PROG.
BOTH WORKS THE SAME WHEN A ROW IS RETRIEVED,BUT WHEN
THE "SELECT STATEMENT ASSOSIATED IS NOT RETRIEVING A ROW "
THEN
A)
%SELECT():-NO NEW ROW OF DATA IS PUSHED INTO STATE RECORD
THER BY THE STATE RECORD CONTAINS THE OLD DATA SINCE NO NEW
VALUES ARE INTIALIZED.
B)
%SELECTINIT():-NO NEW ROW OF DATA IS PUSHED INTO STATE
RECORD BUT THE FILEDS IN THE STATE RECORD INTIALIZED
TO "NULL".
Is This Answer Correct ? | 9 Yes | 2 No |
In case of record level audit what is the structure of table?
What is user profile & security?
How many sub pages, secondary pages can you create in one level?
What will be the output of an application engine to use component variables instead of state record?
What is message catalog?
What are the benefits of set control field in record field properties?
What is getlevel0()?
What is record group?
Explain how to creating prompt table dynamically for the specified field?
What are the different ways to setup row level security?
What types of audits are supported by people soft?
How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?