| | | |

2009年1月9日

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

posted @ 2009-01-09 14:06 Kevin's Blogy 阅读(400) 评论(0) 推荐(0)

2009年1月8日

DateValue

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

posted @ 2009-01-08 14:54 Kevin's Blogy 阅读(293) 评论(0) 推荐(0)

2009年1月7日

Definition in View&Database

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

posted @ 2009-01-07 13:24 Kevin's Blogy 阅读(200) 评论(0) 推荐(0)

2008年12月31日

Call Crystal Report from Application Engine

摘要： Before doing this, check the conditions below: 1. Make sure Process Definition of the Crystal Report has been setup correctly. 2. Make sure the Process Groups of AE also has permission t... 阅读全文

posted @ 2008-12-31 17:14 Kevin's Blogy 阅读(375) 评论(0) 推荐(0)

Call Query from Application Engine

摘要： Function SG_ExecQuery() Returns boolean; Local string &sOutFile; Local Record &rcdQryRunParms; Local Record &rcdQryPrompts; Local SQL &sqlSelectQryParms; Local number &cnt, &i, &Result;... 阅读全文

posted @ 2008-12-31 09:50 Kevin's Blogy 阅读(447) 评论(0) 推荐(0)

2008年12月26日

Building Registry Search Collections

摘要： If you add content to the portal registry by registering components, you must generate a new registry collection before text searches will be successful on the new content reference. To build a new co... 阅读全文

posted @ 2008-12-26 14:04 Kevin's Blogy 阅读(153) 评论(0) 推荐(0)

Synchronizing Record Definitions With Tables

摘要： Evaluating Modifications to Field and Record DefinitionsIf you change either a field definition or a record definition, you might have to alter the associated SQL table to synchronize it, depending on... 阅读全文

posted @ 2008-12-26 11:27 Kevin's Blogy 阅读(295) 评论(0) 推荐(0)

2008年12月25日

Security Definitions

摘要： PeopleSoft security is designed around three definition types. Permission Lists A set of access rights to application objects, including processes and reports, weblib functions, and other e... 阅读全文

posted @ 2008-12-25 11:14 Kevin's Blogy 阅读(230) 评论(0) 推荐(0)

2008年12月24日

The application server’s position in the PIA system

摘要： When a user navigates through a PeopleSoft application using a browser, a number of things happen under the covers. Below we follow a path that takes a request for a page of data about a student, Mark... 阅读全文

posted @ 2008-12-24 13:14 Kevin's Blogy 阅读(249) 评论(0) 推荐(0)

2008年12月17日

Fix ecqueueinstance Error

摘要： ORA-00001: unique constraint (SYSADM.PS_ECQUEUEINST) violated UPDATE ps_ecqueueinst SET ecqueueinstance = (SELECT MAX (ecqueueinstance) + 1 FROM ps_ecqueue ... 阅读全文

posted @ 2008-12-17 00:36 Kevin's Blogy 阅读(220) 评论(0) 推荐(0)

搜索

常用链接

随笔分类

随笔档案

阅读排行榜

评论排行榜

推荐排行榜

最新评论