Compshack - compshack.com - CompShack.com
General Information:
Latest News:
Code to get the record and count from the data base 5 Jun 2013 | 01:17 pm
Step:1 PeopleCode: Local File &MYFILE; Local string &str_cnt; Local string &FPath; &str_cnt = "Record Name" | Char(9) | "Count"; &FPath = "\\psapsftt\TTEF\OneSource\PC-Inbound\Record.xls"; &MYFI...
Code would useful to create a .txt file thru App Engine 5 Jun 2013 | 01:06 pm
Write the code in PeopleCode Action: Local File &MYFILE; &PS_SERVDIR = (GetEnv("PS_SERVDIR")) | "/"; &FPath = &PS_SERVDIR | "file.txt"; &MYFILE = GetFile(&FPath, "W", %FilePath_Absolute); &MYFILE...
Code useful to view a file 5 Jun 2013 | 01:04 pm
SQLExec(SQL.CSGC_DB_NAME, &NAME); SQLExec("SELECT URL FROM %Table(:2) WHERE DISTNODENAME=:1", &NAME, Record.CDM_DIST_NODE, &URL); &PRCSOUTPUTDIR = &URL | "/CSGC_CSHEET1.pdf"; ViewContentURL(&PRCSOU...
Code useful to open a file 5 Jun 2013 | 01:03 pm
Write the code in PeopleCode Action: &FileName = ; &ret = GetAttachment("RECORD://CSGC_CSHT_ATACH", &FileName, "/" | &FileName, "PS_SERVDIR", True); &PS_SERVDIR = (GetEnv("PS_SERVDIR")) | "/"; &Fi...
Code to hide translate values dynamically 5 Jun 2013 | 01:01 pm
Write the code in RowInit: Local Rowset &Xlat; &FLD = GetRecord(Record.PY_IC_WRK1).GetField(Field.ACCOUNT_TYPE_DD); &FLD.ClearDropDownList(); &Xlat = CreateRowset(Record.PSXLATITEM); &Xlat.Fill("...
Code to know whether the Scheduled App Engine ran to success or not 5 Jun 2013 | 12:59 pm
If &MYRQST.Status = 0 Then /* if Schedule status is success */ &LOOP = 0; While &LOOP = 0 SQLExec("SELECT A.DISTSTATUS, A.RUNSTATUSDESCR FROM PS_PMN_PRCSLIST A WHERE A.PRCSNAME = :1 AND A.PRCSINSTA...
PeopleCode Check Number and Check Letter Functions 14 May 2013 | 03:18 am
Couple PeopleCode functions I came across. One insures a string consists of numbers and one insures a string consists of letters. Function Check_Number(&STR) Returns boolean; &LEN = Len(&STR); If &...
PeopleSoft Object Type List 25 Aug 2012 | 02:41 am
Below is a complete list of all PeopleTools object types with value number and description. VALUE DESCRIPTION 0 Record 1 Index 2 Field 3 Field Format 4 Translate ...
PeopleSoft Data Integrity Error (124,85) 28 Jun 2012 | 04:19 am
Today, I had my first 'Data Integrity Error (124,85)' in PeopleSoft. It occured while I was trying to run a QA external check on the careers page for my client. I was not the only consultant who rece...
Unwanted Save Warnings in Display Only Pages 27 Dec 2011 | 06:24 pm
Use function SetSaveWarningFilter( True);