2011年11月_WTK870424

12月 11月 10月 08月 07月 06月 05月 04月 03月 02月 01月

转载 sqlserver dbo

虽然 SQL Server 2000 包含 CREATE SCHEMA 语句，但实际上并不会像上面所定义的那样创建架构。在 SQL Server 2000 中，数据库用户和架构是隐式连接在一起的。每个数据库用户都是与该用户同名的架构的所有者。对象的所有者在功能上与包含它的架构所有者相同。因而，SQL Server 2000 中的完全限定名称的“架构”也是数据库中的用户。在 SQL Se

2011-11-29 22:22:03 698

转载 Sql Server用户名和登录名的关系总结

以前经常被Sql Server中的用户名和登录名搞迷糊，因为用sa（登录名）就搞定一切东西了，当然这会存在一些安全隐患。网上的文章也貌似讲得很好，但还是不明白。今天决心把这个问题弄明白。mashallah, 看了N多文章加实验后终于弄明白了（学东西最重要的还是要亲自动手试试），现将学到的分享一下，看是否对你有帮助。登录名：服务器方的一个实体，使用一个登录名只能进入服务器，

2011-11-29 22:20:58 681

转载 OLE DB 访问接口 "SQLNCLI" 不包含表 ""TOPIC"."dbo"."PA_VW_USER""。该表不存在，或者当前

日期 2011-11-29 14:42:12日志作业历史记录 (PaSX_ZH)步骤 ID 5服务器 CNSZ020201作业名称 PaSX_ZH步骤名称 step5持续时间 00:00:12SQL 严重性 16SQL 消息 ID 7314已通过电子邮件通知的操作员已通过网络发送通知的操作员已通过寻呼通知的操作员重试次

2011-11-29 15:19:08 4259 1

转载如何看懂ORACLE执行计划

如何看懂ORACLE执行计划一、什么是执行计划An explain plan is a representation of the access path that is taken when a query is executed within Oracle.二、如何访问数据At the physical level Oracle reads blocks of data. Th

2011-11-25 19:26:47 515

转载 DoSave save the current page

DoSaveSyntaxDoSave()DescriptionUse the DoSave function to save the current page. DoSave defers processing to the end of the current PeopleCode program event, as distinct from DoSaveNow, whic

2011-11-18 12:44:31 698

转载 PeopleSoft Internet Architecture Overview

A while back, I gave a brief overview of the PeopleSoft architecture to a group of developers. I figured there might be other PeopleSoftPros out there that may need to present this type of overview to

2011-11-17 23:14:31 556

转载 Using Application Engine to Import Data from Files

You can use application engine to import files into tables in your PeopleSoft Database. Prior to version 8, the only way to programmatically do this was by using SQR. However, you now have the ability

2011-11-17 23:13:01 699

转载 Tuxedo and PeopleSoft review

How Tuxedo and PeopleSoft work togetherIn Tuxedo all data is written to and read from a IPC message cue. Think of a message cue as a little boxes of that reside in memory.Once a user request

2011-11-17 23:08:59 607

转载 PeopleSoft Functional Requirements Questionaire

Whether you are modifying a page, an app engine, PeopleCode, SQR, or component interface, you need to gather pertinent information before beginning any modification. This will help you determine the f

2011-11-17 23:06:47 471

转载 The uses of Application Engine

Application Engine was a tough program to use in earlier versions. It did not have a good development tool to help understand the program flow as well as having key constructs missing. The program was

2011-11-17 23:05:34 442

转载 Set Processing vs Row Processing

The word “Set” in Set Processing comes from the mathematical definition meaning a group of elements. In the case of database programming, a row of data is a single element and a “set” would be a group

2011-11-17 23:04:41 520

转载 Securing Your PeopleSoft Application Environment: An Oracle Red Paper

Whether you are a PeopleSoft technical user, installers, system administrator, or a PeopleSoft developer, security is of vital importance to you and your organization. PeopleSoft has many different l

2011-11-17 23:01:12 495

转载 Level 0 means there is no scroll, meaning you will only have one row of data.

EFFDT problem when in level0 Topic List | Next Topic ><!--div.ygrp-photo {background-color:white; border:1px solid #666666; height:62px; overflow:hidden; width:62px}

2011-11-16 23:38:54 1193

转载 How to Capture the Row Selected on Search Page In a Variable?

How to capture the row selected on Search Page in a variable? Which event should I write and how do I access those values?I am trying capture the Row that is selected from the Search Result on the

2011-11-16 23:20:13 532

原创 PeopleCode events: SearchInit, SearchSave and RowSelect

Remember:One thing you must know about peoplecode events is that component processor has some mean to check whether any peoplecode is written on an event or not and if there is no code written on an

2011-11-16 23:07:24 692

转载 Find the Menu Navigation for PeopleSoft Components or Processes

If you're like me, there are a lot of times when you need to make changes to a particular component or perhaps you need to run a particular process. You might know the component or processess name, bu

2011-11-15 22:44:37 587

转载 The PeopleSoft Component Buffer and Component Processor

The PeopleSoft application is an extremely powerful and highly configurable product that runs many different applications. Every application that is accessed online through the PeopleSoft Internet Ar

2011-11-15 22:42:19 679

转载 My PeopleSoft Disaster Recovery Adventure

It was a sunny and cool mid-afternoon Tuesday late in the fall. Everyone in the office was back from lunch, and I was looking at another relatively uneventful week of production support. The financial

2011-11-15 22:36:46 1454

转载 Tracking PeopleSoft usage with Google Analytics

I’ve been using Google Analytics to track how users use my web site for years now, but it just occurred to me that Google Analytics would be a powerful way to track usage in a PeopleSoft system as wel

2011-11-15 22:27:07 822

转载 How to Clear the Application Server Cache Without Shutting it Down

How to Clear the Application Server Cache Without Shutting it DownUpdated 4.9.2008: It is often necessary to clear the physical cache files on the PeopleSoft application server. You would think

2011-11-12 18:21:24 778

转载 Set Component Changed and Search Edit?

Set Component Changed and Search Edit?Reply from Sidharth Ghai | posted May 14, 2007 | Replies (2)Set component changed property is as good as peoplecode prop

2011-11-12 17:25:11 845

转载 Disable Saving Page 取消弹出你有数据没有保存的窗口

Hi, I have custom Save button in the page as opposed to PS delivered one. I haven't put DoSave in this button's fieldchange event for a reason.I have peoplecode behind custom save button to save

2011-11-10 23:26:50 761

转载 Extract PeopleCode from the Database

If you want to create a file that contains all the PeopleCode for a project (or database) you can use theFind In. . .feature, and search for ";". Be sure to select Save PeopleCode to File. (Do not u

2011-11-08 23:31:30 556

转载 A Couple of Must-have PeopleCode Coding Standards

A Couple of Must-have PeopleCode Coding Standards2011年10月30日 | 标签: PeopleSoftThe following are a couple of I believe not well-known coding standards for PeopleCode that I strictly adhe

2011-11-07 22:50:55 674

转载 Direct access to component

Yet another thing I learned this week. It is possible to open a component directly, bypassing the search page — of course after logging in — from a URL link. In the URL, just add the search key field

2011-11-07 22:08:05 694

转载 Advanced Run Control Techniques for Process Scheduler

This posting focuses on pulling together information from the run control (or report request) and the runtime statistics. The original question came from the followingITTOOLBOX posting.Restating

2011-11-07 22:03:42 728

转载 Inside PeopleSoft trees – or – Photosynthesis at PeopleSoft

Created on Friday, 12 August 2005 15:33Written by Larry GreyI’ve talked with many PeopleSoft customer who have needed to use PeopleSoft trees outside of nVision, Query, or Cube Manager. One of the s

2011-11-07 22:01:18 976