PeopleSoft/SQR technical development PeopleSoft/SQR technical development PeopleSoft/SQR technical development
• Mail/phone
  Search
  Keyword:
  Tools
SQR Debugger
 
 
 
 TECH TALK
Lightly technical observations on PeopleSoft and related topics
 

Archive


05/07/2008   Ignoring component-changed state
04/30/2008   App Engine
04/02/2008   Commenting code
03/05/2008   The "Powered By" page
01/30/2008   Formats in PeopleCode variables
01/09/2008   Page layout with group boxes
12/19/2007   Meta-SQL wrappers
12/05/2007   Derived record PeopleCode
11/28/2007   A Cancel button
11/07/2007   "Leading" the test effort
10/31/2007   Temporary tables in SQR
10/24/2007   Updating long character data
10/17/2007   Record.Field specification
10/03/2007   RELLANG.SQC
09/26/2007   Migrating project definitions
09/19/2007   Derived records
08/29/2007   Positioning elements on pages
08/22/2007   Thanks
08/08/2007   SQR "code alerts"
08/01/2007   Styles in HTML Areas
07/25/2007   Dynamic SQL for performance?
07/18/2007   Page Field Name
06/27/2007   PeopleCode event order
06/06/2007   Formatting Excel files using HTML
05/23/2007   Component-changed state
05/16/2007   Selecting styles for page fields
05/02/2007   Sending email from SQR
04/25/2007   Contractor networking
04/18/2007   Project X--and another project
04/11/2007   Effective and data entry dates
04/04/2007   A PeopleSoft home page
03/21/2007   Hyperion and the future of SQR
03/14/2007   The data doesn't lie
03/07/2007   Hyperion acquisition
02/28/2007   Taking ownership
02/21/2007   Source control
02/14/2007   Sandboxes
02/07/2007   Migration instructions
01/31/2007   PeopleSoft environment usage
01/24/2007   Multiple environment strings
01/17/2007   Multiple testing environments
01/10/2007   PeopleSoft support environments
01/03/2007   A single source of truth
12/27/2006   Smile
12/20/2006   Navigating the component buffer
12/13/2006   JavaScript and styles
12/06/2006   SQL for common HR queries
11/29/2006   SQR program complexity
11/22/2006   Frequent SQR questions
11/15/2006   Followup
11/08/2006   Expanding subrecords
10/25/2006   Bind variables
10/18/2006   Attaching objects to projects
10/11/2006   Partial transaction completion
10/04/2006   The multi-process component
09/27/2006   Employee rows lost to security
09/20/2006   SQR document sections
09/13/2006   Empty-string comparisons in SQL
09/06/2006   Nulls, blanks and empty strings in SQR
08/30/2006   Company policy
08/23/2006   Auto-lookup exclusion
08/16/2006   Effective status
08/09/2006   PeopleSoftCity
08/02/2006   A couple of HRMS/HCM utilities
07/26/2006   Translate value changes
07/19/2006   Updating views
07/12/2006   Set-based updates
07/05/2006   SQL set-based processing
06/28/2006   Being happy about bugs
06/21/2006   Busy in the PeopleSoft marketplace
06/14/2006   2-way documentation
06/07/2006   Interfaces as views
05/31/2006   Hijacked fields
05/24/2006   Agile software development
05/17/2006   Working within Waterfall
05/10/2006   Over the Waterfall
05/03/2006   Experimentation in PeopleSoft
04/26/2006   Unlimited enhancements?
04/19/2006   Testing direct database updates
04/12/2006   Delayed evaluation of SQL in SQR
04/05/2006   Database compares
03/29/2006   Support problem? Call the FBI
03/22/2006   Finding SQR errors
03/15/2006   Finding PeopleSoft Queries
03/08/2006   PeopleSoft Query support
03/01/2006   JOB table and SetIDs
02/22/2006   Migrating the project
02/15/2006   Compare and Report options
02/08/2006   Comparing and migrating projects
02/01/2006   Object security in App Designer
01/25/2006   Command-line automation of App Designer
01/18/2006   Contractors on PeopleSoft projects
01/11/2006   "Smart coding"
01/04/2006   Debugger tricks
12/28/2005   Effective dates and component processing
12/21/2005   Referential integrity
12/14/2005   Menu navigation using SQL
12/07/2005   A coding standards wish list
11/30/2005   More App Designer options
11/23/2005   Pages in App Designer
11/14/2005   Finding objects on the menu
10/31/2005   Magic search record fields
10/24/2005   Documenting object attributes
10/17/2005   Monitoring server performance
10/10/2005   Searching PeopleCode
10/03/2005   Speeding up App Designer
09/26/2005   Using the message catalog
09/19/2005   Good ideas that sometimes aren't
09/12/2005   And now Siebel
09/05/2005   Date comparisons
08/29/2005   FTP options
08/22/2005   Code portability across environments
08/15/2005   Spring cleaning
08/08/2005   Build your own SQR "IDE"
08/01/2005   Change control in Application Designer
07/25/2005   Application Engine: disadvantages
07/18/2005   Application Engine: advantages
07/11/2005   Coding Excel file output
07/05/2005   Creating Excel files
06/27/2005   Dave's next move
06/20/2005   SQR variable oddities
06/13/2005   SQR arrays
06/06/2005   Compiling SQRs
05/30/2005   5-character SETIDs
05/23/2005   Use all of the keys
05/16/2005   Dynamic SQL in SQR
05/09/2005   Running the in-place conversion
05/02/2005   Searching for fields in the database
04/25/2005   Converting setup data
04/18/2005   Associating effective-dated tables
04/04/2005   Upgrading without an upgrade
03/28/2005   Scheduling patches
03/21/2005   To patch or not?
03/14/2005   Basic tools
03/07/2005   Way back with sqrtools.com
02/28/2005   Meta-SQL
02/21/2005   Dropping the user index
02/14/2005   User indexes
02/07/2005   Page changes in App Designer
01/31/2005   Generating SQL updates from SQL
01/24/2005   SQR report viewer
01/17/2005   Bug or enhancement?
01/10/2005   Tagging objects and code
01/03/2005   Issue tracking
12/27/2004   PeopleSoft 10?
12/20/2004   Purging tables
12/13/2004   Acquisition
12/06/2004   Exporting PeopleCode as text
11/29/2004   Simplify SQR code
11/22/2004   New site for SQR information
11/08/2004   Comparing objects
11/01/2004   Applying SQL-from-SQL
10/25/2004   Generating SQL with SQL
10/18/2004   Generating SQL
10/11/2004   Scrambling data
10/04/2004   What's going on at PeopleSoft?
09/27/2004   Print Positioning in SQR
09/13/2004   Oracle vs. PeopleSoft
09/06/2004   Word, email, and lava lamps
08/30/2004   Custom run control - part 2 (tips)
08/23/2004   Custom run control - part 1 (building)
08/16/2004   PeopleCode, behind the scenes
08/09/2004   Language-specific pages
08/02/2004   Using substitution variables
07/26/2004   SQR substitution variables
07/19/2004   HTML areas
07/12/2004   Recursion in SQR
07/06/2004   SQR code formatting
06/28/2004   Debugger beta release
06/21/2004   Application Designer tidbits
06/14/2004   Configuration for custom SQR
06/07/2004   Modify or clone?
06/01/2004   Identifying custom objects
05/24/2004   EFFDT again
05/17/2004   Changes-only interfaces (implementation)
05/10/2004   Changes-only interfaces (concept)
05/03/2004   Cache troubles
04/25/2004   Component PeopleCode
04/18/2004   EFFDT and EFF_STATUS
04/11/2004   SQL performance in subselects
04/04/2004   Denormalized tables
03/28/2004   Documenting retired customization
03/21/2004   Sharing login IDs
03/14/2004   Global and local variables in SQR
03/07/2004   DISPLAY and MOVE
02/29/2004   Run control in SQR
02/22/2004   Frequent sources of SQR bugs
02/15/2004   Initial implementation setup data
02/08/2004   Managing setup data
02/01/2004   Managing objects
01/01/2004   Make a home page

 

  HOME  |  ABOUT US  |  PRODUCTS  |  SERVICES  |  TECH TALK  |  LINKS  |  SQR  |  CONTACT
© 2003-2006 SparkPath Technologies, Inc. & its licensors. All rights reserved. Trademarks used are property of their respective owners. | Terms of Use