What is the difference between %Select and %SelectInit in
Application Engine Peoplecode.
- 4 Answers
- 30636 Views
- Accenture, I also Faced
- E-Mail Answers
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 ? | 38 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 |
What are query tables?
What are the benefits of set control field in record field properties?
Tell me how to migrate roles from one database to another database?
How can a component have more than one search record? Give a situation.
What is default processing?
What is portal (structure and content)?
What is file layout definitions?
Both BEA WebLogic and IBM WebSphere have the ability to plug in to many different web servers. Does PeopleSoft support the web servers that they plug into?
What are benefits and draw backs of sqlexec function?
What are the differed processing advantages?
How can you improve the security and usability of a prompt table edit?
Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?
PeopleSoft HRMS 
