RE: [sqr-users] Training question

["Everett Carr" <ECARR@holycross.edu>]

I too, have replied privately to Laura. She is located relatively close to my 
work location. Moreover we have a few former employees sprinkled over at UMass. 
I provided Laura my direct work number and indicated would be happy to discuss 
and provide samples of decent sqr code and explain WHY it is decent vs. 
boilerplate peoplesloppy code. 

>>> "the dragon" <ceprn@hotmail.com> 7/24/2006 4:08 PM >>>
I'd be happy to teach her how to code in SQR the right way, if I had the 
time to do so.  Unfortunately, my next vacation isn't until October, and I 
don't think she wants to wait that long.

Having worked with SQR since it's MITI incarnation, and PeopleSoft since v 
6.5; if you used PS delivered SQRs to learn, then you may have a basic 
understanding of SQR, but it is more an example of how not to code in SQR 
than how to code in SQR.  It's certainly not efficient code, and it lacks 
robustness, as well as being difficult to understand.  My guess is that 
rather than developing code by hand, they use the query tool and then copy 
in the sql from there.

Just my opinion based upon 12 years of SQR, 14 years of SQL and 9 years of 
PS.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

Hi Laura
Sorry that your request for help has ended up with a lot of useless comments 
(want to go to the bathroom, smoking stuff, etc etc.).  If you hate sqr, 
peoplesoft, or both, that's fine - All the lady wanted was some help.

I'm not sure what version of PS they are familiar with, and while PS's SQRs 
might boilerplate or whatever else, they can be a good start if you are just 
beginning with sqr...then you can go on to the more fancy features (if you 
even call it fancy) of sqr.  There was a time I knew nothing of SQR and 
believe it or not, I got going fairly quickly thru exposure to PS's sqrs.  
By the way, I am doing a version 8 implementation of PS right now and will 
be going live in a month and haven't had to "fix" any of their delivered 
sqrs...so they are a decent baseline which you can use.  If you are on PS, 
pick a simple report like OMS1000 or something of that nature to see simple 
report formatting - make sure the sql you have in your procedure(s) actually 
returns data thru whatever sql tool you use.

On the other hand, if one of these folks wants to take the time to teach you 
sqr and help debug your code, then ignore my comments above.

Chris

-----Original Message-----

Pleasse, you REALLY should have warned me to go to the bathroom and relieve 
myself before reading this.

Peoplesoft TEST?   A company that on multiple occassions that ships source 
code that won't even compile due to syntax errors........  I don't need 
whatever it is you've been smoking.

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/ 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users