Hot To Store Output Of A Sql Query In A Variable Using Peoplecode?

1.	Hot To Store Output Of A Sql Query In A Variable Using Peoplecode?
Answer» USING SQLExec FUNCTION SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &AMP;Emplid, &Name); Using SQLExec Function SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &Emplid, &Name);

Answer»

SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &AMP;Emplid, &Name);

Using SQLExec Function

SQLExec (“SELECT EMPLID,NAME FROM PS_PERSONAL_DATA”, &Emplid, &Name);

Discussion