Re: New SQR'r

[Ken Boettger <BoettgeK@CWU.EDU>]

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