Rounding Error
Some people use the term “rounding error” to indicate that an answer is right enough, although not perfectly right. Those people think “accurate” and “precise” are two different concepts. ...
Read MoreAuthor: Steven Alexander
Merging Bundles With Customized Peopletools Objects
Posted by Steven Alexander | Feb 28, 2010 | Application Designer, Peoplesoft Specific |
We’re always happy yet apprehensive to get a new bundle of bug fixes for Peoplesoft. We anticipate that our applications will run more reliably, perhaps faster, and maybe with a few new features. The chore that nobody...
Read MoreThe Rewrite And The Bug Fix
Posted by Steven Alexander | Feb 21, 2010 | Algorithms |
Last week I worked on two SQR program bugs. I rewrote the first one from scratch. I wanted to rewrite the second one but didn’t. Here is why. The Rewrite My organization has an in-house timecard system. After the...
Read MoreAvoid Subqueries
Posted by Steven Alexander | Feb 14, 2010 | Peoplesoft Specific, SQL |
I have nothing against subqueries, but there are times in the Peoplesoft environment that they are unnecessary. If we can get exactly the same results with simpler, faster SQL, let’s avoid subqueries. PS_EMPLOYEES...
Read MoreDynamic Views in Application Designer
Posted by Steven Alexander | Feb 7, 2010 | Algorithms, Application Designer |
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements. The Peoplesoft Application Designer also lets us create dynamic views, which we may use within the page processor....
Read More
Recent Comments