Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     {OPEN] Function to include quotes in a value

Read-Only Read-Only Topic
Go
Search
Notify
Tools
{OPEN] Function to include quotes in a value
 Login/Join
 
Mayank Agrawal
Member
posted
Hi
I want to know is there any function existing in WebFocus for putting any value or number inside a single Quote.
For Example if a vaiable RTM = 20
I want to have like '20' in any other Variable.
Its urgent.!!
Please Reply asap.
Thanking You.
Regards
Mayank Agrawal
 
Posts: 28 | Registered: April 11, 2011Report This Post
MurthyRSN
Member
posted Hide Post
You can use EDIT to get quotes to values.


WebFOCUS v7.7.05
Windows 7
HTML/EXCEL/PDF/AHTML
 
Posts: 2 | Registered: June 08, 2011Report This Post
<FreSte>
posted
... or ...

-SET &ECHO='ON';

-SET &RTFM = ITALY;

TABLE FILE CAR
SUM DEALER_COST
WHERE COUNTRY EQ &RTFM.QUOTEDSTRING
ON TABLE HOLD
END
 
Report This Post
jfr99
Platinum Member
posted Hide Post
A couple other examples .......

-*
-SET &RTM = 20;
-SET &RTM_Q1 = '''' | &RTM | '''';
-SET &RTM_Q2 = EDIT(&RTM,'''99''');
-*
-TYPE RTM ------- &RTM
-TYPE RTM_Q1 ---- &RTM_Q1
-TYPE RTM_Q2 ---- &RTM_Q2
-EXIT
-*


WebFocus 8.201M, Windows, App Studio
 
Posts: 227 | Location: Lincoln Nebraska | Registered: August 12, 2008Report This Post
ABT
Master
posted Hide Post
quote:

-SET &RTFM = ITALY;


Bwahahahahahahahaha

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
<FreSte>
posted
Not subtle enough Smiler

This message has been edited. Last edited by: <FreSte>,
 
Report This Post
Waz
Expert
posted Hide Post
Is this for a dialog manager variable ??


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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Baillecl
Platinum Member
posted Hide Post
Too subtle for me.
But Google told me what RTFM meant.
Thanks to ABT to help slow minded
Cordially and Slow Mindedly
PS : I wouldn't name a Field DATE if I were giving examples to a NewComer. (I used to be a famous player in "the Dinner Game")


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Report This Post
ABT
Master
posted Hide Post
quote:
...
WHERE COUNTRY EQ &RTFM.QUOTEDSTRING
...


Ths is a complete sidebar, but when the heck is DevStudio going to get Intellisense / type ahead / code complete? I am envious of the Microsoft tools for this.

I'll be the first to say that i personally didn't know there was a QUOTEDSTRING method, but if there was intellisense you;d see it and every other available property.

WebFOCUS.Net?

-ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
<FreSte>
posted
.. so the name of the variable was not a bad choice afterall Smiler

There are some more I know of:
-SET &VAR1 = 12;
-SET &VAR2 = 'ABC';

-TYPE &VAR1.TYPE
-TYPE &VAR2.TYPE

-TYPE &VAR1.LENGTH
-TYPE &VAR2.LENGTH

-TYPE &VAR2.EXIST
-TYPE &NOVAR.EXIST


,but I agree with you, some more intelligence would be very much welcome
 
Report This Post
Waz
Expert
posted Hide Post
quote:
Microsoft tools


CPU time wasters.....

If you need point and click and "autocomplete" then you don't know the language.


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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<JJI>
posted
I have to agree with Fred and ABT. Some more intenlligence would definitely be appreciated by most developers.
Autocomplete is the one I would prefer the most.
Autocomplete helps you to develope quicker and does not mean that you don't know the language!!!!!
 
Report This Post
Waz
Expert
posted Hide Post
quote:
does not mean that you don't know the language


Conthe contrary, it creates an environment of assumptions, and you could end up with code that you don't want if you're not checking what its "autocompleting".

Perhaps its just the option of a bit of a programming dinosaur. I always hated predictive test stuff in mobile phones.


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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     {OPEN] Function to include quotes in a value

Copyright © 1996-2020 Information Builders