2009年1月9日

摘要： Use the following code to call a batch file or executable from an SQR. Put the complete path of the batch or executable in the variable $command_line. If $message is not 0 then you have an error from ... 阅读全文

摘要： Below is a good SQR tip for stripping out special characters from those nasty Phone Number formats stored in HRMS. begin-procedure main . . do parse_phone($phone_number, $phone_number) . . end-proc... 阅读全文

摘要： Below is a sample piece of SQR code which you can use to call Datamover to export data perform some processing, and call another SQR within that SQR to posibly load the data. It's a good sample! !**... 阅读全文

摘要： Here is a worthy tip to take note of. If you are going into a new page and using a search view, yet you already know the keys of that search view, you can use the PeopleCode function SetSearchDialogBe... 阅读全文

摘要： Here's a quick way to send an email message from within peoplecode. You can also send attachments along with your email message. Simply use the PeopleCode command SendMail to send an email message fro... 阅读全文

摘要： Tracing an application engine program can be easily done without modifying the trace settings in your application server. Here are some simple guidelines to follow to trace an app engine program. Go... 阅读全文

摘要： If you have a drop down list on a page and want to place items into the drop down list dynamically, here is a bit of insight on how to do it. This tip is taken from our discussion forum thread How t... 阅读全文

摘要： There are many occassions where you might want to find the difference in time or days between two dates. Use the PeopleCode function known as DateDiff. The %DateDiff meta-SQL function returns an int... 阅读全文

摘要： I'm sure you are aware that PeopleSoft has built in Field Level Auditing that allows you to track any adds, changes, or deletes to a specific field in a record. This is good to use at times when you... 阅读全文

摘要： There have been many requests from PeopleSoft Pros wanting to call an appengine program from PeopleCode. Some refer to this as "Real-Time Application Engine Processing." For example, when a user save'... 阅读全文