Re: New SQR'r

[Denise White <dewhite@VICR.COM>]

Hi Ken,

There are a few more problems with your code, but maybe you just didn't
reproduce it exactly in your message, since you seem to be saying that it is
working fine now.  Anyway:

You need a hyphen in 'end-select', instead of 'end select'.  Also, the variables
that you are assigning the selected columns to need prefixes to show the data
type.  Assuming they are character fields, your variables should be '$f1' and
'$f2', not 'f1' and 'f2'.  If they are numeric, use a '#' instead of '$'.

HTH,
Denise White
Sr. Programmer/Analyst
Vicor
------------------------------

Date:    Mon, 1 Apr 2002 13:57:30 -0800
From:    Ken Boettger <BoettgeK@CWU.EDU>
Subject: Re: New SQR'r

Thanks. It was the parenthesis.  They were not explained well in the manuals I
have here.  I just needed that empty set of
parens. Thanks.

-Ken

>>> spatel@ADMIN1.UMARYLAND.EDU 04/01/02 12:05PM >>>
Ken,

Try this...

begin-select
T.field1 () ON-BREAK PRINT=NEVER AFTER=<some proc when break occurs; you can
also use BEFORE>
T.field2
        let f1 = &T.field1
        let f2 = &T.field2
       print f1  (+1,5)
       print f2  (,20)
from table1 T
end select


-----Original Message-----
From: Ken Boettger [mailto:BoettgeK@CWU.EDU]
Sent: Monday, April 01, 2002 2:33 PM
To: SQR-USERS@list.iex.net
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