Re: SQR Debug Software

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

I agree. SQR Tree is very good.

-----Original Message-----
From: Karver [mailto:basic@GATEWAY.NET.AU]
Sent: Tuesday, August 21, 2001 9:50 AM
To: SQR-USERS@list.iex.net
Subject: Re: SQR Debug Software


Hi Lorraine,

I see Peter may have already satisfied your request with his utility.  If
you are still struggling though you may be interested in a utility I wrote
called "SQR Tree".  It's primary function is to provide an interactive tree
of the procedure calls in an SQR program.  However in your particular case
you may find the Search facility useful because it can search for a string
across both the SQR and all it's subordinate SQC files, allowing you to
quickly determine whether those suspect variables are used or not.

SQR Tree is available from the Library section of the SQR Users Group web
site at http://www.sqrug.com .

Regards

Wayne Ivory

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Peter Clark
Sent: Tuesday, 21 August 2001 1:18 AM
To: SQR-USERS@list.iex.net
Subject: Re: SQR Debug Software


Hi Lorraine,

I have a little utility I put together a while ago that might help you. It
is a listing utility with a cross-reference option that would help you track
down unreferenced variables (and find valid variables that are in SQC's).
I'll mail it direct to you.

Regards,
Peter

>>> "Ballesty, Lorraine" <lorraine.ballesty@ROCHESTER.EDU> 2001/08/20
1:32:56 pm >>>
Without going into too many details, we unfortunately had a consulting firm
in that didn't do us any favors.  So, yes - we have some bad programming.
(I think one of them was a contortionist.)

By unused/suspicious, I am referring to 2 specific problems I frequently
encounter in the process of debugging/rewriting.

The first is unused variables:  I end up tracking them down, thereby wasting
my time in an effort to weed them out.

The second category includes the following:
*       variables which look as if they might be unused, but are actually
referenced in an sqc.  (Again, a pain to track down.)
*       variables which are mispelled - for instance, using $Emplid and
$Emplids interchangeably.

If there isn't something 'ready made', then I'll go ahead and code something
to deal with the problem.

> -----Original Message-----
> From: the dragon [SMTP:ceprn@HOTMAIL.COM]
> Sent: Monday, August 20, 2001 12:17 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: SQR Debug Software
>
> Lorraine,
>
> What do you mean by unused/suspicious variables?  if you're talking about
> variables which are referenced but don't exist, sqr will identify those at
> compile time and whine about it. if you're referring to variables which
> get
> created and never used - those are a sign of bad programming, but won't
> affect the processing of the sqr.  Now, then, to answer the question you
> asked, I am not aware of anything.  It sould be easy to write a Unix shell
> script using grep, awk and sed to accomplish this, if it really needs to
> be
> done.
>
> clark 'the dragon' willis
> dragon enterprises, consulting services
>
>
>
>
>
> ----Original Message Follows----
>
> Good morning -
>
> Does anyone know of any existing 'add on' SQR debug software?
> Specifically,
> we would like to find something that can search an SQR program for unused
> and/or suspicious variables.
>
> Thanks for any help you can give!
>
> Lorraine Ballesty, Analyst/Programmer Lead
> HRIS, Information Technology Services
> University of Rochester
> phone:  (716) 273-2606
> pager:  (716) 220-0803
> e-mail: LBallesty@ACS.Rochester.edu
>
>
> PSA: Salary <> Slavery.  If you earn a salary, your employer is renting
> your
> services for 40 hours a week, not purchasing your soul.
>
> NOTICE:  The information contained in this message is protected under
> United
> States and international copyright laws and is intended for the personal
> and
> confidential use of the addressee.  If you are not the addressee or an
> agent
> of the addressee, you are hereby notified that you have received this
> message in error and that any review, dissemination, distribution, taking
> of
> any action in reliance upon or copying of this message without the express
> written permission of the sender or his agent is strictly prohibited and
> in
> violation of referenced statutes.  If you have received this message in
> error, please notify me (the sender) immediately and you are instructed to
> delete this message from any computer it resides on, including mail
> servers.
>
> SIGNATURE :
> Do not meddle in the affairs of dragons, for you are crunchy and taste
> good
> with ketchup.
> You've got to be a Spirit; don't need no Ghosts.
> Do or Do Not; There is NO Try.
> Any clod can have facts, but having an opinion is an art !
> A conclusion is simply the place where someone got tired of thinking.
> When a continuing state of defiance and disorder can not be checked by the
> rules, then new and sometimes drastic rules must be forged to maintain
> order; the alternative is anarchy.
> M. Clark Willis III - Sr Systems Analyst, Sr Consultant ceprn@hotmail.com
> aolim:ceprn ICQ 6633136
>
> Help stamp out SPAM!! http://www.cauce.org
>
> The senders of unsolicited commercial e-mail to me at any site are liable
> for a $500 per message cost under USC 47, which may be found at
> http://www.law.cornell.edu/uscode/47
> Contents of this message, in it's entirety, (c) 2000 M. Clark Willis III /
> Dragon Enterprises inc.  All rights reserved.
>
>
>
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp