摘要：q/?ICAction=ICQryNameURL=PUBLIC.XLD_HR_RPT_006XLD_HR_RPT_006为query名称 阅读全文

摘要：The following SQL identifies custom queries created in your system from thePSQRYDEFNPeopleTools table. It includes the query type (and the operator ID who owns the query if it is private).selectQRYNAMEas"Query Name",DESCRas"Query Description",CREATEOPRIDas"Created By",C 阅读全文

摘要：There could be different reasons why a PeopleSoft developer would like to delete a query from the database. Upgrade clean up would probably be the most common one. Here is a function you can use to get you started.Function DeleteQuery(&sQueryName As string) SQLExec("DELETE FROM PSQRYDEFN WH 阅读全文