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

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

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

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

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

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

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

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