[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Select Columns in Left Margin
- Subject: Re: Select Columns in Left Margin
- From: "Jeff T. Orwick [C]" <orwick@CIG.MOT.COM>
- Date: Wed, 3 Apr 1996 09:50:34 -0600
- In-Reply-To: =D6rjan Nordlund <orjan.nordlund@BROTTSFOREBYGGANDERADET.SE> "Select Columns in Left Margin" (Apr 3, 1:23pm)
- References: <199604031209.IAA00550@po_box.cig.mot.com>
No you haven't over looked anything its the way the parser works. You can
however place more than one column on the same line if separated by a comma.
I've been using SQR for 3 years now and WOULD NOT recommend this solution.
The best way to deal with it esthetically that I've found is this.
begin-procedure proc_name
begin-select
table.column1 &co1
table.column2 &co2
to_char(table.column3) &co3
print &co1 (+1,1,10)
print &co2 (,+1,20)
print &co3 (,+1,9)
from table
where ...
end-select
end-procedure
I know it's not what you're hoping for, but, if you're consistent, your eye
quickly learns to distinguish the pieces.
--
Jeff T. Orwick orwickj@tusc.com <- Full time address
http://www.tusc.com