Therefore, the best and safest way to launch an SQR program is to use the People Code functions CreateProcessRequest() and Schedule(). The CreateProcessRequest function allows you to create a Process Request object. Remember, you should be coding your People Code programs using the Object Oriented methods. Once you’ve created your object, you can assign values to its properties and use the Schedule method to submit the process request for scheduling. The CreateProcessRequest function takes 2 arguments. The Process Type and the Process Name.
REM Declare your Variables;
Hi Friends,
For scenario like i want to increase Emplid value when am click search page automatically.
It is possible in Rowinit Peoplecode.
Sample Code:
If %mode = "A" then /*A Means add mode */
SQLExec("Select max(Emplid) from ps_abc",&a); /* &a is a variable */
&a=&a+1;
PS_ABC.Emplid.value=&a;
gray(PS_ABC.Emplid);
end-if;
Regards,
Mahendra
Hi Friends.
Instead of Print command, by using String.So that we can get each and every row one time in either CSV/HTML/XML output format.
Example:
Print $Name(,)
Print $Name (,)
Print $Address2(,)
Print $State (,)
Print $Country(,) /* Use Strings here to remove multiple duplicate rows of data*/
STRING $Name $Address1 $Address2 $State $Country BY ',' INTO $ST1
STRING $N ,............................................................ BY ',' INTO $ST2
STRING $ST1 $ST2 BY ',' INTO $ST3
PRINT $ST3 (+1,1)
Regards,
Mahendra
Hi Friends,
Calling Dynamic Sction Dynamically:
Open Application engine program and insert the section with action(action like call section).Here select the Dynamic Calling check box,then open Peoplecode action with OnExecute event and write the Dynamic calling section Peoplecode like....
Evaluate Recrod.Field ----- Evaluate PS_JOB.EMPLID
WHEN "N"
PS_JOB.AE_SECTION.Value="VALIDALL" /*Call here which sction is required to retrieve the data*/
Break;
WHEN = "Y"
PS_JOB.AE_SECTION.Value = 'LOADDATA' /*Call here loading data sction*/
Break;
End-Evaluate;
Regards,
Mahendra
Hi Friends,
Yes,we can write multiple SQL Statements by using %Execute Function.(Pls refer in Peoplbooks if required).
Example: Scenario1:
Open one SQL Action.............
%EXECUTE (/)
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
/
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
/
DELETE PS_JOB WHERE ROWNUM=10;
Note: Here forwardslash is optional to commit the statment.
Scenario2:
%EXECUTE()
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
COMMIT;
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
COMMIT;
Hi All,
Custom Objects in PeopleSoft: Custom objects are the objects built by a PeopleSoft client to accommodate their business needs.
Customized Objects in PeopleSoft: Customized objects are the delivered objects from PeopleSoft to which the client made some changes to accommodate their business requirements.
If am wrong please correct me.
Regards,
Mahendra
Following is the query that can be useful to find out all records under a specified component. All it requires is the component name, and type of record you want to check For example pass value as "0" to retrieve only record type as 'Table' under specified component
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 17 weeks ago
2 years 22 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 24 weeks ago
2 years 24 weeks ago
2 years 26 weeks ago
2 years 28 weeks ago
2 years 31 weeks ago
2 years 37 weeks ago