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 |
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?
What is difference between saveprechange and savepostchange?
What is record meta data?
Explain how to creating prompt table dynamically for the specified field?
can we call an sqr with in an sqr
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?
Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?
what is section?
What is record group?
What is differed processing?
Tell me the use of set control field in record field properties?
Explain does peopletools 8.4 support web server load balancing?