Function hasGenlDedCd(&EMPLOYEE, &COMPANY, &DEDCD) Returns boolean; Local Record &rec = CreateRecord(Record.GENL_DED_CD); Local string &exists = ""; &rec.EMPLID.Value = &EMPLOYEE; &rec.COMPANY.Value = &COMPANY; &rec.DEDCD.Value = &DEDCD; SQLExec("select 'x' from %Table(:1) where %keyEqual(:1)", &rec, &exists); Return All(&exists); End-Function;
This space was created to keep track of little tips or tricks and examples of code. At the moment it is mostly PeopleSoft and PeopleCode examples.
Code Style
Labels
- App Engine
- App. Designer
- Application Packages
- Arrays
- Auto Numbering
- Components
- Data Archive Manager
- Dates
- Error Handling
- Evaluate
- Exceptions
- Fields
- File Layouts
- Function
- Grids
- HTTP Requests
- Insert
- Leading Zeros
- messages
- Meta-SQL
- Node
- Oracle
- PeopleCode
- PeopleSoft
- Performance
- Records
- Routing
- Search page
- SHOWTBAR
- SQL
- State Records
- Stylesheets
- Tips
- Translate
- Web App.
Tuesday, January 14, 2014
Simple Row Exists logic
Here is a nice quick way to find if a row exists in peoplecode.
Labels:
PeopleCode
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment