Focal Point
[SOLVED] EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: CONCAT

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6657049586

March 24, 2017, 06:43 AM
rboya
[SOLVED] EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: CONCAT
Hi,

I am trying to use Concat function. But it is throwing error

EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: CONCAT

here is the code

-SET &v1 = 'Test';
-SET &v2 = 'Example';
-SET &v3 = CONCAT(&v1,&v2);
-TYPE &v3;

Could you please help.

Thanks

This 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;

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.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

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().
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.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code