摘要： 在所做的几个项目中都做过导出系统数据到EXCEL中，但屡次都出现导出长串数据到EXCEL中后显示为科学计数法，在网上查找了些方法,大致有两种解决途径：一种是最不方便但能解决问题的方法，使用EXCEL的字符类型设置将科学计数法在EXCEL文件中转换为文本类型此类方法可通过打开EXCEL，通过菜单的文件---->打开---->选择导出的EXCEL文件 在弹出的设置窗口中设置字段的类型为文本... 阅读全文

摘要： The OPRID (USER) that has "locked" this run control from continuing on should take the followings steps: 1. Go to the Details link for the process that has No Successed, if the process is a sub proces... 阅读全文

摘要： You could E-Mail the Query results by embedding the paramters in a nVision Layout. Create a Tabular nVision Layout. Add the Query parameters to the Tab. Then, when you execute the nVision Report on... 阅读全文

摘要： Same way as a delivered record (or you can add audits to a delivered record if it doesn't already have them). You can either turn audit on for individual fields or build a custom audit record. To au... 阅读全文

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