Posts

Showing posts from September, 2019

AE : Application Engine

Application Engine 1.It is a People Tool  and It is used to develop batch programs or online programs that perform the backed processing against the data. 2.It consists of the 2 distinct components .They are Designer->Consists of the batch programs. Run time Environment->To run and monitor the programs. 3.A program is a set of SQL statements. 4.It does not generate SQL or PeopleCode, but it executes SQL or PeopleCode as a part of program. 5.It is designed for batch processing where data must be processed without user interaction. 6.AE resides on database server. APPLICATION ENGINE PROGRAM ELEMENTS: ====================================== 1.PS AE consists a set of processes to execute a given task and made up of several elements.They are i)  Sections It is a set of ordered steps that gets executed as a part of the program.The execution of the program starts with the section defined as MAIN. ii)  Steps Steps are the smallest unit of the program that can be committed  within a

PC: Save Project Peoplecode into file

Save Project Peoplecode into file: If you want to save the entire peoplecode of your project you can do it through application designer. Bellow are the steps to save peoplecode to file. In application designer 1.Go to Edit->Find In option. 2.Enter find character as semicolon(;) and select your project. 3.Check the Save PeopleCode to file option. 4.Click Find button it will ask a file name. 5.Provide the file name and location where you want to save the file. Then the peoplecode of your project stored into file.

PC : Add Drop-down values through peoplecode

Add Drop-down values through peoplecode /* Get the field reference into &field variable */ &field = GetRecord(Record.CH_EMPTYPE).GetField(Field.CH_EMPMAIN); /* Delete all the values from dropdown list */ &field.cleardropdownlist(); /* Add values to the dropdown list */ &field.adddropdownitem(Descr, Value);    [Value]: It is actual value which is mapped to the dropdown item    [Descr]: It is actual text which is visible as a dropdown item Examples: &field.adddropdownitem("A", "A"); &field.adddropdownitem("B", "B"); &field.adddropdownitem("C", "C");

PC : PeopleCode for disable the row delete option in scroll and grid

PeopleCode for disable the row delete option in scroll and grid For &i = 1 To &Asmfloor.ActiveRowCount    &Asmwing = &Asmfloor(&i).GetRowset(Scroll.ASM_WING_TBL);    For &j = 1 To &Asmwing.ActiveRowCount       &Asmcabin = &Asmwing(&j).GetRowset(Scroll.ASM_CABIN_TBL);           If &Asmcabin.ActiveRowCount = 1 Then          &Asmwing.DeleteEnabled = True; /* to enable the row delete option */          If &Asmwing.ActiveRowCount = 1 Then             &Asmfloor.DeleteEnabled = True;          Else             &Asmfloor.DeleteEnabled = False; /* to disable the row delete option */          End-If;          rem &Asmfloor.DeleteEnabled = True;       Else          &Asmwing.DeleteEnabled = False;          &Asmfloor.DeleteEnabled = False;             End-If;         End-For; /* end-of wing */             End-For; /* end-of floor */

PC : PeopleCode to find special characters in file other than ASCII characters

PeopleCode to find special characters in file other than ASCII characters Local string &File_path, &File_path1; &File_path = "C:\temp\ascii.xml"; &bud_rep = GetFile(&File_path, "r", %FilePath_Absolute); &File_path1 = "C:\temp\ascii_1.txt"; &bud_rep1 = GetFile(&File_path1, "a", %FilePath_Absolute); &count = 0; While &bud_rep.readline(&line)    &line1 = Len(&line);    &count = &count + 1;    For &i = 1 To &line1       &char = Substring(&line, &i, 1);       &naciichar = Code(&char); /* returns the number corresponds to character */       /* check whether the character is in the range of ascii char's or not */       If &naciichar >= 128 Or             &naciichar < 0 Then          &bud_rep1.writeline(&count | " " | &char); /* write special character to file */       End-If;    End-For;

PS :Changing table space of a record.

PeopleSoft : Changing table space of a record. If you want to assign a record to the new table space that you created open your record, and go to Tools --> Data Administration --> Set Table space. then you can assign new table space to record.