I have a subsequent issue I am trying to resolve now regarding language translation. I have an HTML page with a double list selection box. The HTML page passes the field name(s) as it exists in the table to fulfill a variable in the fex called &COL. So, using the car file, I might have COUNTRY CAR and MODEL on the report and the next person that might run this report might ask for COUNTRY CAR MAKE and MODEL on the report, etc etc. The HTML operation that is passed is 'AND' so the Print statement in the fex comes out PRINT COUNTRY AND CAR AND MODEL, etc etc. Ok, so..now...lets say the person requesting the report is asking for their data to come back in French. The double list select box will display the fields to choose in French..but under the covers passes the field name. Once that comes in to satisfy the &COL variable I need to get those field names into their French translation. Were it a static list of fields every time the report is run, no problem. But it is dynamic, with 47 fields in the list and any possible order the user wants to see.
Any suggestions?

This message has been edited. Last edited by: MonkeyP,

interesting. Assuming the fex receives a string like you say COUNTRY AND CAR AND MODEL, then you could do a GETTOK and seperate the tokens with ' AND ' (notice spaces). Then do a FOR loop to spit out the field names with a .EVAL (i.e. &VAR_NAME.EVAL AS '&VARNAME').

This is coming out jumbled -- I did something similar where I had to loop through days, looking at each day individually (not as a range). I used a FOR loop to do this and then wrote each to a hold file with the loop number in it. Later, I stitched them back together using another loop to write out the WebFOCUS code in the middle of a MORE FILE routine. The .EVAL caused it to be seen as code and executed. Yours will be a little different in that you don't have a loop that increments, so you have to fool it by tokenizing the string.

I hope this helps.
- ABT

With a multi-select HTML object, WebFOCUS creates an array for the variable. For example, your &COL becomes &COL, &COL1, &COL2, &COL3, &COL4, etc. But based on your previous post, where you mentioned the use of a translation table, you might be able to do something like this:

DEFINE FILE translation_table
 QUOTE/A1 = ''';
 PRINT_COL/A50 = COL_NAME | ' AS ' | QUOTE || COL_TITLE || QUOTE ;
END
-* 
TABLE FILE translation_table
 PRINT PRINT_COL
 WHERE (COL_NAME EQ '&COL');
 WHERE (LANGUAGE EQ 'FRENCH');
 ON TABLE SAVE AS PRINT_COLS
END
-*
TABLE FILE data_table
 PRINT
-INCLUDE PRINT_COLS
END

EDIT: Sorry, I forgot about the ANDed values in &COL. Therefore, you would need to separate the values in order to 'OR' them for the translation table query:

DEFINE FILE translation_table
 QUOTE/A1 = ''';
 PRINT_COL/A50 = COL_NAME | ' AS ' | QUOTE || COL_TITLE || QUOTE ;
END
-* 
TABLE FILE translation_table
 PRINT PRINT_COL
 WHERE LANGUAGE EQ 'FRENCH';
 WHERE COL_NAME EQ '&COL1'
-SET &I = 2 ;
-REPEAT ENDREPEAT WHILE &COL.&I.EXISTS ;
    OR '&COL.&I.EVAL'
-SET &I = &I + 1 ;
-ENDREPEAT
;
 ON TABLE SAVE AS PRINT_COLS
END
-*
TABLE FILE data_table
 PRINT
-INCLUDE PRINT_COLS
END

This message has been edited. Last edited by: Dan Satchell,

ok, thanks for giving me something to get my brain going. I will work on this over the weekend and let you all know how it comes out.

Thanks!

Wendy

Thanks Dan, that looks like a fleshed out version of what I was trying to describe.

- ABT

Well, GETTOK only returns the first character of any token you identify..so if the operations is AND it is only returning the 'A'. Secondly, I am using a double list control box, not a mutliselect list box, and it is actually NOT returning multiple &variable values. It is returning the value for &COL as COUNTRY AND MAKE AND MODEL. If I query the variables with ? & it doesn't show &COL and &COL1 and &COL2 etc etc...it only shows &COL. Any additional suggestions?

Maybe something like this. Use function STRREP to replace all ' AND ' with commas in order to generate a comma-delimited list of column names. Use this column list in your query. You may have to adjust the STRREP function to put single quotes around each of the column names.

-SET &COL_LIST = STRREP(&COL.LENGTH,&COL.QUOTEDSTRING,5,' AND ',1,',',&COL.LENGTH,'A&COL.LENGTH.EVAL');
-*
DEFINE FILE translation_table
 QUOTE/A1 = ''';
 PRINT_COL/A50 = COL_NAME | ' AS ' | QUOTE || COL_TITLE || QUOTE ;
END
-* 
TABLE FILE translation_table
 PRINT PRINT_COL
 WHERE (COL_NAME IN (&COL_LIST));
 WHERE (LANGUAGE EQ 'FRENCH');
 ON TABLE SAVE AS PRINT_COLS
END
-*
TABLE FILE data_table
 PRINT
-INCLUDE PRINT_COLS
END

Boy, I fought and fought with this. GETTOK wouldn't behave properly..and neither would STRREP. In an act of desperation, I replaced the "AND" operation in the HTML code with just a space (" ") and now the field names, no matter how many and in what order, come across as a list so now I can match them to the translation table and produce the report in the correct language.
Go figure.....