Focal Point
Cannot save procedure containing %u

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4891030722

May 08, 2007, 11:08 AM
Ron F
Cannot save procedure containing %u
If I create any procedure containing the character string %u, the procedure will refuse to save:

TABLE FILE CAR
PRINT
CAR
MODEL
BODYTYPE
SALES
WHERE MODEL LIKE '%u';
END

Try to save and you get "Unable to save file IBFS://blah/blah/blah/wildcard.fex"


Any idea why this is and if there is a workaround? I'm using version 7.14
May 08, 2007, 11:18 AM
Kamesh
I tried to save it on my DevStudio 7.1.6 it worked.


WFConsultant

WF 8105M on Win7/Tomcat
May 08, 2007, 11:24 AM
Leah
I tried it in 7.1.6 MRE and it worked, but it doesn't work in 5.3.6 MRE. I have Java 1.6.1 installed as the Java 1.5..9 would not allow report caster to run under 5.3.6, go figure.


Leah
May 08, 2007, 11:51 AM
KevinG
In 7.1.3, I don't even get an error message...the combination of '%u' wipes out all code in the fex.

Kevin


WF 7.6.10 / WIN-AIX
May 08, 2007, 12:02 PM
KevinG
Furthermore,

It happens in every editing tool in Dev Studio including Notepad. Notepad works fine outside of the Dev Studio environment, but trying to save a fex to a Reporting Server with Notepad from Dev Studio gives the same behavior...contents of fex are wiped out!!!


WF 7.6.10 / WIN-AIX
May 08, 2007, 12:25 PM
Ron F
quote:
I tried to save it on my DevStudio 7.1.6 it worked.


Thanks. I'll see what we have available to upgrade to.
May 08, 2007, 04:06 PM
Ron F
I upgraded Developer Studio to 7.61 and I am still getting the error. I'm guessing this is caused by the WebFocus server (which is still on either 7.14 or 7.16) and not the Developer Studio client as I initially thought. I guess I'll have to wait until our sysadmin has a chance to upgrade.
May 08, 2007, 05:03 PM
susannah
have you tried using the pipe, which is the escape character for the & ?
&|U
or, the unicode value of the & sign, which you can google.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 14, 2007, 03:56 AM
hammo1j
This is another example of why C++ is such a dangerous language to write applications in.

%u is a formatting character that can be embedded in a stream write function (eg printf) to expect a unformatted int as part of the argument. The wf code is not providing it hence the write fails.

btw This is a standard method your C++ code can be hacked!



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo