Four Js Customer Forum

Hi,

MAIN
  define i smallint = NULL
  define s string

  let s = 'i = ' || Nvl(i,0) USING '<<&'             # concatened with ||
  display s                                ------>            RESULT = "0"


  let s = 'i = ',Nvl(i,0) USING '<<&'                  # concatened with ,
  display s                                                       RESULT = 'i = 0'

END MAIN

Regards

Hello Benjamin,

The || operator has a higher precedence as USING

Try with parenthesis:

     LET s = 'i = ' || (NVL(i,0) USING '<<&')

See:

https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#fgl-topics/c_fgl_operators_CONCATENATE.html

https://4js.com/online_documentation/fjs-fgl-manual-html/?path=fjs-fgl-manual#fgl-topics/c_fgl_operators_014.html

Seb

Hi,

Yes indeed, the documentation is clear

Sorry