Re: Concatenation operator in embedded SQL statements in 4GL

Posted in 1997

David Williams — Mon, 9 Jun 1997 23:57:17 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <EBIq88.FJp@nonexistent.com>, Jacob Salomon <jake@apparel.net> writes >Hi Family, > >I just tried the following in a 4GL program: > > select col1 || col2 > into myvariable > from some_table > >The 4GL compiler actually generated a syntax error for this! >;-( I had >to go through the PREPARE/DECLARE/OPEN/FETCH rigmarole. > >Considering that the || concatenation operator has been available in the >engine since 4.1 or so, I find it incredible that the 4GL 6.05 syntax >checker can't handle it. > That's true - it is not valid syntax. >Anyone know if this is a known bug? Or some outstanding feature request? Not a bug and probably not a feature request....after all 4GL has full variable handling i.e. is a full programming langague. >It certainly was not expected behavior! > >Thanks. > -- David Williams