[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



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