- 博客(29)
- 资源 (99)
- 收藏
- 关注
转载 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 4260 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 695
转载 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
原创 新建了一个wordpress的blog www.80-man.com,欢迎访问
新建了一个wordpress的blog www.80-man.com,欢迎访问
2011-11-03 23:15:39 704
转载 Defining PeopleCode Events
Every PeopleCode program is associated with a PeopleSoft Application Designer definition and with an event. Events are predefined exit points in the component processor flow. As each point is encounte
2011-11-01 23:54:19 549
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人