What is the difference between %Select and %SelectInit in
Application Engine Peoplecode.

Answers were Sorted based on User's Feedback



What is the difference between %Select and %SelectInit in Application Engine Peoplecode...

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

What is the difference between %Select and %SelectInit in Application Engine Peoplecode...

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

What is the difference between %Select and %SelectInit in Application Engine Peoplecode...

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

What is the difference between %Select and %SelectInit in Application Engine Peoplecode...

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

Post New Answer

More PeopleSoft Tools Interview Questions

What is auto update?

0 Answers  


Explain how to taken care performance management in people tools?

0 Answers  


Situation: you want to migrate database from one database to another. How would you do that?

0 Answers  


What is the use of primary permission list in user profile?

0 Answers  


What is message catalog?

0 Answers  






What is the use of temporary records and state record in application engine?

0 Answers  


What is mandatory property of app.engine?

0 Answers  


What is difference between field default and row init?

0 Answers  


what is section?

1 Answers  


How can you improve the security and usability of a prompt table edit?

0 Answers  


What is an array in people code? What is maximum dimension of an array?

0 Answers  


How many sub pages, secondary pages can be created in one level?

1 Answers  


Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)