Toos 8.54: SQLExec
edited Apr 25, 2016 10:42AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered
This is a basic question - We have the following code in AE
SQLExec("UPDATE PS_HRS_HIRE SET EMPLID=:1, HRS_ROW_UPD_OPRID=:2, HRS_ROW_UPD_DTTM=:3 WHERE HRS_HIRE_SEQ=:4 AND HRS_JOB_OPENING_ID=:5 AND HRS_PERSON_ID=:6", &emplidDisplay, "N_0054HR_AE", %Datetime, N_HR_NWHIR_AET.HRS_HIRE_SEQ, N_HR_NWHIR_AET.HRS_JOB_OPENING_ID, N_HR_NWHIR_AET.HRS_PERSON_ID);
SQLExec("UPDATE PS_HR_REQUEST SET EMPLID=:1 WHERE HRS_PERSON_ID=:2", &emplidDisplay, N_HR_NWHIR_AET.HRS_PERSON_ID);
Issue - First Step always updates PS_HRS_HIRE table. Second step, does not always update PS_HR_REQUEST table
0