Re: New SQR'r

[Ken Boettger <BoettgeK@CWU.EDU>]

Thanks Rod,

That did the trick.

I was reading the book this morning and the reason I came up with this 
question.  It doesn't explain the usage of the parenthesis well under ON-BREAK 
or in the Break section of the User's Guide.

Thanks for your help.

-Ken

>>> rwright@THEROUSECOMPANY.COM 04/01/02 11:54AM >>>
You need to give it something to do when a break occurs. For example:

   MHD.DEPENDENT_BENEF         () on-break print=never level=1
   after=DepBenefChange

You seem to need the () before the on-break. They are part of a print
statement, telling SQR where to print the information. Since you don't want
anything to print, you give it the "print=never" option. The "level=1"
option tells SQR that this is a level 1 break, as opposed to level 2, 3,
etc. This is not required in all cases. the "after=DepBenefChange" tells
SQR to execute the DepBenefChange procedure after the value changes. I
suggest looking up the syntax for on-break. It's associated with the Print
statement.

Rod






Ken Boettger <BoettgeK@CWU.EDU>@list.iex.net> on 04/01/2002 02:33:00 PM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Software's database reporting language"
      <SQR-USERS@list.iex.net>


To:   SQR-USERS@list.iex.net
cc:

Subject:  New SQR'r

begin-select
T.field1
T.field2
        let f1 = &T.field1
        let f2 = &T.field2
       print f1  (+1,5)
       print f2  (,20)
from table1 T
end select


Everything works fine until I put an ON-BREAK on field1:

begin-select
T.field1 on-break
t.field2
       let f1 = &T.field1
       let f2 = &T.field2
       print f1  (+1,5)
       print f2  (,20)
from table1 T
end select

 With this, I get errors that read:

 "Columns names and expressions must be unique or be given unique
pseudonyms (&name)."
 "Referenced variables not defined"

Can someone help explain to me the problem here?  It seems the code is
valid as it runs fine until I insert the ON-BREAK.  Thanks.

-Ken