What is the difference between %Select and %SelectInit in
Application Engine Peoplecode.
- 4 Answers
- 32030 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 ? | 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 |
can any one suggest me about the certifications for pepole soft enterprise one
How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?
What is change control?
Is web server load balancing supported with PeopleTools 8.4?
Are disconnected mobile applications supportedin PeopleTools 8.1x?
What is file layout definitions?
Explain how the output of a sql query be stored in a variable using peoplecode?
Tell me the use of temporary records and state record in application engine?
What is the difference between component buffer and data buffer?
Explain what is process scheduler information?
What are table edits?
What are the benefits of set control field in record field properties?
PeopleSoft HRMS 
