Concatenation operator in embedded SQL statements in 4GL
Posted in 1997
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. Anyone know if this is a known bug? Or some outstanding feature request? It certainly was not expected behavior! Thanks. -- -- Jake (In pursuit of undomesticated aquatic avians) +----------------------------------------------------------+ |Aside from that, how did you enjoy the play, Mrs. Lincoln?| +----------------------------------------------------------+