Archive: Page 13

SQR: Removing Special characters from a String
This week was hectic! Though we had a very normal start, a couple of critical job failures knocked us midweek taking away all our coffee breaks! Once the jobs were… Read more

SQR: Reading from Flat File and Updating a Record
This post is in response to Fred’s request on ToD. He had asked for an SQR program that would read from a flat file and update the values to a… Read more

Topics on Demand [ToD]
Introducing Topics on Demand! If you have a topic that you would like us to cover, this is where you can ask for it. Once we get some requests, one… Read more

Updating multiple fields with values from another table
While carrying out day-to-day support for PeopleSoft systems, we often encounter cases where fields in a record must be updated with values from another table. In this post, we will… Read more

Radio buttons / Drop down / Prompt : What to use?
We have seen developers using Radio buttons, Dropdowns and Prompts – most often interchangeably! Can we use these interchangeably? Of course, they will work! But what about performance? Will it… Read more

PeopleCode FieldEdit Event
FieldEdit PeopleCode fires for the field and the row that just changed. So, to validate the input entered by a user into a field, you may write PeopleCode in the FieldEdit event of that particular filed.

PeopleCode Events: FieldFormula
The PeopleCode Event FieldFormula can get triggered in many different contexts and can execute the PeopleCode on every filed on each row in the Component Buffer. As this can degrade the performance of the system considerably, this event is hardly used.

PeopleCode Events: FieldDefault
If you want to set a default value to a field on your page from PeopleCode, then FieldDefault PeopleCode event is the place that you should be looking for. FieldDefault PeopleCode can be associated with record fields and component record fields.

PeopleCode Event: FieldChange
The PeopleCode FieldChange event fires just after a change to the contents of a field has been made. It fires on the particular field that has changed. You can find the FieldChange event in Record Fields as well as Component Record Fields.

PeopleCode Event: Page Activate
Pages in PeopleSoft have an Activate event that gets fired every time you navigate to the page. If there are multiple pages in a component, this event fires each time… Read more