[sqr-users] Dynamic array addressing?

[Kevin Laroche <bydesign@magma.ca>]

Hi to all
I have inheirited some bloated code full of tidbits like this
      let Array1.col(#i,9) = Array1.col(#i,9) + 1
   and
     let Array1.col2(#i,9) = Array1.col2(#i,9) + 1
   and
     let Array1.col3(#i,9) = Array1.col3(#i,9) + 1

I could really put this report on a diet if I could code something like this

    if a variable = 1
         let $column_number = 'col'
    end-if
    if a variable = 2
         let $column_number = 'col2'
    end-if
    if a variable = 3
         let $column_number = 'col3'
    end-if

    let Array1.[$column_number](#i,9) = Array1.[$column_number](#i,9) + 1

I know you can use dynamic SQR for select where and order by.  Can it done for 
arrays or
is there a better way that I have missed?

Thanks to all

Kevin LaRoche
at the Canadian Human Rights Commision
Ottawa Ontario

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users