In this article, we will see step by step procedure to attach a file and store it in the database. The article also shows how to view and delete the uploaded file. Assume that you have item table (PS_QNN_ITEM) with ITEM_ID as a key and basic item information such as Item Name, Description etc . […]
Drop variables from a SAS data set when all its values are missing… Source http://support.sas.com/kb/24/622.html
How to recursively iterate through Exception object and prepare a formatted error message?
ASP.NET allows developers to access configuration settings from within an application either by exposing configuration settings directly (as strongly typed properties) or by using general configuration APIs. The following sample shows a page that accesses the <browserCaps> configuration section using the Browser property of the System.Web.HttpRequest class. This is a hash table of attributes that […]
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements.
PeopleSoft 8 provides the functionality to create dynamic views. These are essentially SQL statements executed on the fly by the PeopleSoft component processor. We can use dynamic views in Peoplesoft pages only because they are Peopletools objects, not SQL Objects.
Using Dynamic as Prompt Table
In this article, we will see the use of Dynamic view as prompt table. Please note that dynamic view can be used for other purposes such as search records which will not discussed in the article.
One major question that pops up to many of us the first time we use dynamic view, why not use a normal view instead of dynamic view. A dynamic view’s select statement may include Peoplesoft’s meta-SQL, and it may be replaced by a different SQL statement while the user is using the page. And also there might be situations where which you do not save the view in the database.
A central requirement of any Web application server is a rich and flexible configuration system-—one that enables developers to easily associate settings with an installable application (without having to “bake” values into code) and enables administrators to easily customize these values post-deployment, The ASPNET configuration system has been designed to meet the needs of both […]