Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 albe
		
			albe
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
I would like to create list boxes by reading an external parameter file containing the name of the fields and a flag to choose if they should be displayed in a list box.
Do you have an idea to do this ?
I tried creating a table that has the name of the fields to be displayed in list boxes, but I don't know how to choose the list box field using an expression.
Thank you for your help.
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
one possible solution to this might be:
=$(=Only({$<ShowFieldID={1}>} NameOfField))
=$(=Only({$<ShowFieldID={1}>} ShowField))
Using a table containing the field names and show flags:
tabShowFields:
LOAD RecNo() as ShowFieldID, *
INLINE [
    NameOfField, ShowField
    Field1, 1
    Field2, 0
    Field3, 1
    Field4, 1
    Field5, 0
    Field6, 1
    Field7, 0
    Field8, 1
];
tabData:
LOAD Ceil(Rand()*20) as Field1,
     Ceil(Rand()*20) as Field2,
     Ceil(Rand()*20) as Field3,
     Ceil(Rand()*20) as Field4,
     Ceil(Rand()*20) as Field5,
     Ceil(Rand()*20) as Field6,
     Ceil(Rand()*20) as Field7,
     Ceil(Rand()*20) as Field8
AutoGenerate 30;
hope this helps
Marco
