Compshack - compshack.com - CompShack.com

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);

Related Keywords:

oracle minus, oracle group by, oracle substr, peoplesoft pia, peopletools security tables, peoplecode for loop, using sqltext in level 1 peoplecode, psprojectdefn, oracle group by rollup, staging table

Recently parsed news:

Recent searches: