Peoplesoft Tools Question: Download Peoplesoft Tools PDF
How the output of a sql query be stored in a variable using peoplecode?
Answer:
You can use SQLExec to do the same.
SQLExec("SELECT EMPLID FROM JOB",&Emplid);
The value of EMPLID gets stored in the variable &Emplid.
SQLExec("SELECT EMPLID FROM JOB",&Emplid);
The value of EMPLID gets stored in the variable &Emplid.
| Previous Question | Next Question |
| Explain the numbers of sub pages and secondary pages that can be created in one level? | How to creating prompt table dynamically for the specified field? |