[sqr-users] #Define variables

["Kevin Laroche" <bydesign@magma.ca>]

Hi all
I am trying to write dynamic reports that resize columns based on the #Define 
no_columns
variable.  I would like to add a feature so that if the user selects a 
particular
subset of data the report automatically adds a column and resizes all the 
column widths.

I have been using 
#define no_columns   8
at the start of the report then I calculate  the size of the columns from there

My question is...

This works but the report has to input the number of columns
and I prefer not to link the form and the report that closely
!--start of program
#Define no_columns   8
BEGIN-PROGRAM
input #no_columns 'number of columns'
#Define no_columns #no_columns
!{no_columns} is redefined here to whatever number I want

!--much more code
END-PROGRAM

This doesnt work
!--start of program
#Define no_columns   8
BEGIN-PROGRAM
input $user 'Enter a user name'
IF $user = 'XXXX'
   let #no_columns = {no_columns} 
   let #no_columns = #no_columns + 1
   !{no_columns} is not redefined here -results are uncertain at best
   #Define no_columns #no_columns
END-IF

!--much more code
END-PROGRAM

Any suggestions from the guru's ?

Thanks

Brio 6.1 on Windows 2000 with Oracle 8i


Kevin LaRoche - Oracle Forms and Brio too
Ottawa Ontario


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