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

What is auto update?

0 Answers  


Where do you write the peoplecode?

0 Answers  


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

0 Answers  


what isthe difference between SQL View and Query View?

4 Answers  


What are the different ways to suppress the Search page when a component is opened.

3 Answers  






what is section?

1 Answers  


Tell me how many sub pages, secondary pages can you create in one level?

0 Answers  


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?

1 Answers  


What is default processing?

0 Answers  


When we select a component what events will be fired?

0 Answers  


What is maximum dimension of an array?

0 Answers  


What is difference between field default and row init?

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)