I have a fex with a launch page which prompts for variables: YEAR, MONTH and DOGID. In the SQL database the fields are written in mixed case (i.e. Year, Month, DogId), and remain in mixed case in the HOLD file after a
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HF1
END
?FF HF1
-RUN
I am trying to pass these values from the launch page to the report focexec to be used in WHERE statements. Here is my code in the focexec:
-DEFAULT &MONTH = ‘ ‘ ;
-DEFAULT &YEAR = ‘ ‘;
-DEFAULT &DOGID = ‘ ‘ ;
………………………………….
TABLE FILE WHATEVER
PRINT
FLD1 FLD2
BY Year
BY Month
BY DogId
WHERE Year EQ ‘&YEAR’;
WHERE Month EQ ‘&MONTH’;
WHERE DogId EQ ‘&DOGID’;
END
-RUN
What happens is the launch page prompts me for these 3 variables as anticipated. Then a 2nd launch page displays and asks me to provide selections to these variables all over again !!
There is an intermediate page that runs between the launch page program and my report fex. This page contains HTML form coding which passes hidden values and (the 3) variables to the report fex. The Year, Month and DogId fields are referenced in this page in CAPITAL letters as YEAR, MONTH and DOGID.
My problem is I am having trouble getting the –DEFAULT command to work with these variables that are referenced as either MIXED CASE or CAPITAL letters. Do I reference the fields in mixed case in the –DEFAULT or as CAPITAL letters? What reference do I use in the WHERE statement?
Has anyone had experience with this? Thanks!This message has been edited. Last edited by: FP Mod Chuck,