Re: Select Columns in Left Margin

[johnk@SUN4.MITI.COM]

     The need to differentiate column names from SQR command is indeed the
     main reason that column names are required to be placed at the left
     margin. The need arises from SQRs ability to allow commands to be
     embedded in select blocks. For example:

     begin-select
     column
       let #variable = #variable + &column
       print #variable (+1,1)
     from table
     end-select

     We are looking at an enhancement that would allow indentation of the
     begin-select block, thus re-defining the left margin for that select
     block only. The code could look like this:

     begin-procedure main1
      do main2
     end-procedure

       begin-procedure main2
         begin-select
         column
           let #variable = #variable + &column
         from table
         end-select
       end-procedure

     John L. Kellogg
     MITI Technical Support Manager

______________________________ Reply Separator _________________________________
Subject: Select Columns in Left Margin
Author:  usa.net!SQR-USERS@netcomsv.netcom.com at Internet
Date:    03/04/96 5:24 AM


Does anyone know why you have to place column names at the left margin in
SELECT paragraphs? The User's Guide explains that it is to differentiate
column names and commands. Couldn't there be a more aesthetical solution? A
structured program in SQR is because of this an oxymoron...

Have I perhaps overlooked any "work around" of this matter?

Orjan Nordlund
National Council for Crime Prevention Sweden