Focal Point
[CLOSED] Reporting object fields Case

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

December 14, 2009, 08:41 AM
derekas
[CLOSED] Reporting object fields Case
Hi,

Does someone knows how to configure WebFocus (server/client) so that field:
aaa/I5 = 0;
and
Aaa/I5 = 0;

would be recognised as same field?

the problem is that in reporting object there was defined field 'aaa' after few weeks it was renamed as 'Aaa' and all reports created by user not work now...

Anyone knows how to solve that easy? with a SET or Some variable?

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


WebFocus 7.6.10
Windows Xp Profesional, Linux
Excel, Html, PDF
December 14, 2009, 09:45 AM
GinnyJakes
You could try the LET command.

Or do string searches in all the .fex programs in basedir to identify all of the programs that need to be changed. Then run some sort of script to change them en masse.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
December 14, 2009, 10:01 AM
Tony A
quote:
Anyone knows how to solve that easy?
Find the person responsible .....

And then educate them Wink

Seriously though, Ginny has already suggested changes en-bloc and I guess that's the best way forward.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 14, 2009, 03:54 PM
Waz
The best way forward would be to get all occurances of aaa or Aaa to be the same.

Adding in a LET statement will work, but in the future may cause many problems and misunderstandings.

Sometimes you need to do the hard yards to get a more robust system.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 14, 2009, 04:11 PM
GinnyJakes
And since I'm old school, I never define a field in mixed case, ever. If I want it to look pretty, I give it an AS name.

In the olden days, we didn't have a mixed case option so old habits die hard, but they keep you out of trouble as well.

You might want to consider a 'best practice'.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
December 14, 2009, 04:21 PM
Waz
I agree with you Ginny, Best Practice is the way to go. Good One


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!