01 2009 档案

摘要：All PeopleCode objects can be passed as function parameters. You can pass complex data structures between PeopleCode functions (as opposed to passing long lists of fields). If a function is passed an ... 阅读全文

摘要：ExcelToCI里面的Action对应Update和Update Data的区别：Update相当于为父亲添加一个新的儿子，Update Data相当于修改儿子/父亲的信息。 阅读全文

摘要：Local File &File; Local string &FILE_NAME, &CHARSET, &COMPANY_NAME, &COMPANY_PADDED, &LINES_PADDED, &AMOUNT_PADDED; Local number &LINES, &AMOUNT; Local Record &HEADER_REC, &TRANSACTION_REC; Local SQL ... 阅读全文

摘要：To set up alternate character functionality in PeopleSoft HRMS: Link the alternate character sets with language codes on the Installation Table - Alternate Character page (ALT_CHAR_TBL). ... 阅读全文

摘要：If you are an Oracle DB customer, you should learn about Oracle hints. Oracle hints influence the Oracle optimizer to your advantage. Here is an example of a hint. Example: select /*+ ALL_ROWS */ em... 阅读全文

摘要：Get the O/S environment variables from within SQR programs There is a function called GetEnv(). This gets the TEMP environment variable on the machine where SQR is run. Returns the value of the spec... 阅读全文

摘要：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'... 阅读全文

摘要：If you have any specific fields that are lengthy and are left padded with zeroes, you can save your users a lot of time by alowing them to type ONLY the right most numbers. For example, lets say you... 阅读全文

摘要：DateValue(date_str) Description Use the DateValue function to convert a date string and returns the result as a Date type. date_str must be a string in the active date format user's current personaliz... 阅读全文

摘要：Here is the definition in Application Designer: SELECT a.SETID , a.PROD_GRP_TYPE , a.PRODUCT_GROUP , a.DESCR , a.GLOBAL_FLAG , a.eff_status FROM %Table(PROD_GROUP_TBL) a WHERE (%EffdtChe... 阅读全文