Yes the reports are in the same domain. Here is the error I get.
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: test2 FOCEXEC *
July 28, 2004, 08:12 PM
webfocuspgm
You're right.... I had to copy it into my apps_srv path directory before it would pick it up. Not sure why that is.
July 28, 2004, 08:12 PM
<Mike Miles>
Try removing the .fex from the end of the default value. I tried it both ways in an ad hoc query on our system and the FOC227 error did not occur when the .fex was removed.
July 28, 2004, 08:14 PM
webfocuspgm
The .fex didn't seem to matter on my test. It was the test02 being in the apps_srv path that made the difference on mine.
July 28, 2004, 08:46 PM
reFOCUSing
Removing the .fex did not make any difference got the same error. I also tried it with 'app/' and that made no difference.
July 28, 2004, 08:58 PM
webfocuspgm
On your server you should have a directory path that contains the apps_srv path mine looks like this.
WebFocus2004:\ibi-dev\ibi\apps_srv\baseapp
I put test02 in the baseapp directory, made sure my edapath included baseapp and your code worked fine. If I removed test02 from the baseapp it no longer worked.
Maybe a tech from IBI can explain why it needs to be in the apps_srv path, I would have thought the same domain would work.
July 28, 2004, 09:02 PM
Leah
I've used -include for code segments or code and put it in the OTHER files area or the reports area of the domain and it finds it.
IB definitely needs to answer on this one.
July 29, 2004, 01:40 PM
<monte2000>
Hi everyone.
I noticed that you all have asked that IBI step in on this discussion. I will ask around and see which Product Manager may be able to shed some light on this.
Just a reminder - this forum is for customers to help customers. It is NOT an official line of support. Our support staff does voluntarily chime in on some of these discussions (as does the President of the company.) But the only way to guarantee the involvement of our support staff is by contacting them.
If any member is having an issue with the product that they can not solve on the forum, please contact Technical Support or open a case.
Thanks so much for participating in the forums!
Monica
July 29, 2004, 02:01 PM
webfocuspgm
Sorry Monte2000,
Didn't mean to imply that an IBI tech should hop on this thread, it was meant to be an implied - maybe a case should be opened with them and the information gathered and then posted for everyone's reference or for future knowledgebase searches.
This is a great forum !!!!!!!! Thanks
July 29, 2004, 02:21 PM
<monte2000>
Webfocuspgm: Thanks for the compliment on the forum. We plan on re-organizing the forums a bit and having a searchable knowledgebase of these discussions is definitely something we're considering.
CurtisA: I have contacted the product managers and am hoping to shed some light on your situtation.
Cheers everyone and thanks for making the forum a success!
Monica AKA Monte2000
July 29, 2004, 02:35 PM
<Mike Miles>
Are you sure that the name of test2.fex is really test2.fex and not one of the WebFOCUS generated names. Were these FOCEXECs developed in the MRE environment or were they developed manually.
July 29, 2004, 02:41 PM
Leah
In reading Mike's reply, it brings to mind an issue we had in developing a program. I made changes to a fex. The production area had a caster job set up for the fex which I could not see. Turns out what I thought I was changing I wasn't. The name on the properties under MRE of the fex was different from the display name. I understand also if you are on 5.x version it forces the fex name to eight characters if eight are not supplied.
Wouldn't it be nice if that was all it was.
July 29, 2004, 03:04 PM
FocWizard
I think the issue is WHERE the files exist. Are TEST1 and TEST2 on the Reporting Server? Or are they in a domain under MRE? If you're invoking TEST1 from MRE, it tries to do the -INCLUDE locally, so WHERE the files reside is important. There's a section in the MRE Users Manual dealing with -INCLUDE. Basically, to include a report of type:
Can you provide a bit more on the environment? If these procedures are on a Reporting Server, you should be able to invoke TEST1 from an ad-hoc window.This message has been edited. Last edited by: <Mabel>,
July 29, 2004, 03:21 PM
reFOCUSing
Both the files are in the MRE under the same domain and in the same folder. I have checked the properties of both files and they are named test1.fex and test2.fex, I'm running developer studio 5.2.4 and webfocus server and client are also 5.2.4.
July 29, 2004, 03:29 PM
FocWizard
OK, we're talking MRE. The doc says, to incorporate a Standard Report with -INCLUDE, you should code:
-INCLUDE app/filename
can you try that?
July 29, 2004, 03:39 PM
webfocuspgm
At first I thought it was a naming issue. I created a focexec and used test02 which isn't 8 characters. I'm using 5.2.5 and it created a fex with the name test02.fex. The code worked as long as test02 was in my reporting server path, not just my domain.
Yeah, Sorry Curtis I'm actually in the MRE not developers studio. That explains why mine works.... Thanks FocWizard.
July 29, 2004, 03:43 PM
FocWizard
Curtis,
Sorry, now I have a better understanding of what you want. Unfortunately, you can't do it. The issue is, the MRE Dialogue Manager processing is NOT the FULL D.M., but only provides variable substitution. It doesn't really support the '.EVAL' qualifier, which would cause a second 'interpretation' of the line. As a result, the -INCLUDE doesn't see the value as a filename, and can't locate it. That's why you get that error.
August 03, 2004, 03:12 PM
<Pietro De Santis>
I've had nothing but trouble in MRE when trying to INCLUDE a fex that is contained in a variable name. I've tried
But the only way to guarantee the involvement of our support staff is by contacting them. 