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

Explain the difference between temporary table and sql view in peoplesoft?

0 Answers  


Explain what is portal (structure and content)?

0 Answers  


What is difference between saveprechange and savepostchange?

0 Answers  


Which http servers and java servlet engine combinations are supported with peopletools 8.4?

0 Answers  


Situation: you want to create a prompt table dynamically for a specified field. How would you do that?

0 Answers  






How to migrate roles from one database to another database?

3 Answers  


Explain what is file layout definitions?

0 Answers  


What is component meta data?

0 Answers  


What is getlevel0()? What is the use of %subrec and %selectall functions?

0 Answers  


How to store related field data into database?

0 Answers  


For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?

1 Answers  


Explain what is process scheduler information?

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)