As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
This question has been asked before, but the response did not include a sample of code...so...
In WebFOCUS MRE 7.7.02 we have a fex in domain1 that does an -HTMLFORM to an htm file which is located in domain2. The HTMLFORM executes multiple fexes to populate drop down boxes and then when the user clicks on the Submit button a final fex is executed. These three fexes are located in domain2 as well.
The fexes in domain2 are using SQL pass thru and therefore are setting the DEFAULT_CONNECTION to a valid data adapter connection name.
We now want to set up a domain3 to process the same HTMLFORM and the same fexes found in domain2; however we want to use a different value for the DEFAULT_CONNECTION. I think we can set up amper variables in the first fex which calls the -HTMLFORM, and then set up an !IBI.AMP.VARNAME in the htmlform to pass to the three fexes.
I think we would include a -SET &VARNAME = 'ORACLEADT'; in the domain1 fex; We would include !IBI.AMP.VARNAME somewhere in the htm code which is located in domain2; We would change code in the three fexes to ENGINE SQLORA SET DEFAULT_CONNECTION &VARNAME We then would include a -SET &VARNAME = 'ORACLEEUT'; in the domain 3 fex. Notice the value is slightly different for &VARNAME.
Can someone confirm my logic? Also, can someone provide the actual syntax I would use to add the !IBI.AMP.VARNAME in the htm code? Can I just insert it anywhere in the code? Do I need to use any other code around it?This message has been edited. Last edited by: Kerry,