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 ?    39 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

In case of record level audit what is the structure of table?

0 Answers  


What is user profile & security?

0 Answers  


How many sub pages, secondary pages can you create in one level?

0 Answers  


What will be the output of an application engine to use component variables instead of state record?

0 Answers  


What is message catalog?

0 Answers  


What are the benefits of set control field in record field properties?

0 Answers  


What is getlevel0()?

0 Answers  


What is record group?

0 Answers  


Explain how to creating prompt table dynamically for the specified field?

0 Answers  


What are the different ways to setup row level security?

0 Answers  


What types of audits are supported by people soft?

0 Answers  


How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?

0 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)