ThanksThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
March 24, 2017, 12:01 PM
Clif
New simplified FOCUS function CONCAT() is in 8.2.
In earlier releases use
-SET &v3 = &v1||&v2;
N/A
March 26, 2017, 04:30 PM
Waz
FYI
|| or |
| is a soft concatenation, the two vars are just concatenated, including all training spaces
|| is a hard concatenation, the vars are concatenated, but all training spaces from var1 are pushed to the end of var2.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 27, 2017, 03:37 AM
rboya
Thank you. I got it.
Please let me know how to use LCASE(). because I am getting same error as for CONCAT().
EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: LCASE
WebFOCUS 8 Windows, All Outputs
March 27, 2017, 10:47 AM
Clif
When using Dialogue Manager you can't use SQL functions like LCASE(); you can only use FOCUS functions like the simplified function LOWER() which is available in 7.7.06/8.1 or the legacy function LCWORD().
N/A
March 28, 2017, 03:03 AM
rboya
It worked!!.
Thank you very much.
WebFOCUS 8 Windows, All Outputs
March 28, 2017, 04:40 PM
Waz
Hi rboya,
Please edit your first post in this thread and add [SOLVED] or [CLOSED] to the title.